[postgis-users] PostgreSQL 7.3 Improvements?

[Paul Ramsey]

Better index usage can be obtained by enabling Dave's selectivity 
system, which is also in the CVS.

The biggest 7.3 change was in the area of "manageability", as schema 
support was added. This makes larger multi-user sites easier for DBAs to 
manage.

It also raises some interesting PostGIS issues. By default, PostGIS 
installs into the current schema. But maybe it should make its own 
schema, or install into the system schema. The current setup is simplest 
to understand, but long term manageability might be improved by using a 
separate schema. Any expert DBA comments would be useful.

P.

C F wrote:
> Hello,
> I'm not really up to speed on PostgreSQL 7.3 and curious about any 
> improvements.  I read the improvements summary at their site but it's 
> pretty vague.  I'm wondering specifically about the index optimizer... I 
> know in the past there's been issues with 7.2 and earlier not using the 
> optimal index for some types of PostGIS queries.  Anybody know if this 
> is improved in the new version?


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_