Re: 7.4?

scott.marlowe <scott.marlowe@ihs.com>

From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Ericson Smith <eric@did-it.com>
Cc: Postgresql General <pgsql-general@postgresql.org>
Date: 2003-02-24T20:33:40Z
Lists: 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.