Skip site navigation (1) Skip section navigation (2)

Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Bultman <adam(dot)bultman(at)iconideas(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Importing Postgres 7.1.1 DBs into Postgres 7.3.2
Date: 2003-02-19 20:59:04
Message-ID: 14339.1045688344@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-novice
Adam Bultman <adam(dot)bultman(at)iconideas(dot)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

In response to

pgsql-novice by date

Next:From: Robert PratherDate: 2003-02-19 21:44:23
Subject: User Problem In PostgreSQL On Mac OS X
Previous:From: Jeff DeroshiaDate: 2003-02-19 20:45:15
Subject: Re: null value in date field

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group