Re: 7.4? - Mailing list pgsql-general

From scott.marlowe
Subject Re: 7.4?
Date
Msg-id Pine.LNX.4.33.0302241310400.14139-100000@css120.ihs.com
Whole thread Raw
In response to Re: 7.4?  (Ericson Smith <eric@did-it.com>)
Responses Re: 7.4?  (Ericson Smith <eric@did-it.com>)
List pgsql-general
On 24 Feb 2003, Ericson Smith wrote:

> Could someone summarize what would be the 3 changes that would have the
> most impact in 7.4?

I would say the biggest impact from 7.2 to 7.3 are:

- Schemas and their support
- Indexing issues related to using C locale or anything else
- The less greedy type matching changes result in some indexes being
ignored that were once used.
- Old sequences and other things won't inherit dependency.  not a real
problem, just an fyi.

From 7.3 to 7.4 the biggest changes planned so far:
- windows native support <-- gartner gives it a 90% chance of making it
into the main disto... :-)
- fix for in() performance issue <-- already in CVS tip
- partitioning or tablespaces <-- who know?  seriously, who?
- vacuum will be able to compact out unused space <-- Tom Lane
- possible newer settings for the default postgresql.conf could
increase load on some machines to a point they may need to be reconfigured
to come up.

Data wise I don't think there's gonna be a lot that will mess up a 7.3 to
7.4 conversion so far that's gone by.


pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: 7.4?
Next
From: Tom Lane
Date:
Subject: Re: order of database modifications in a single transaction