Postgres Pro
Downloads
Home   >   mailing lists

Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2 - Mailing list pgsql-novice

From Tom Lane
Subject Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2
Date
Msg-id 14339.1045688344@sss.pgh.pa.us
Whole thread Raw
In response to Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2  (Adam Bultman <adam.bultman@iconideas.com>)
List pgsql-novice
Tree view 
Adam Bultman <adam.bultman@iconideas.com> writes:
> Will there be a speed increase, or decrease, with regards to selects,
> blah blah blah?  Things seem to take a while longer on the new system;

I'd expect 7.3 to be quicker on average than 7.1.  Perhaps you missed
some tuning steps?  (VACUUM ANALYZE, getting shared_buffers and other
config parameters up to where they are for the 7.1 system, etc)

            regards, tom lane

pgsql-novice by date:

Previous
From: Jeff Deroshia
Date:
Subject: Re: null value in date field
Next
From: Robert Prather
Date:
Subject: User Problem In PostgreSQL On Mac OS X