I had to run a script which did few thousand queries on 7.1 few times and
after that even the queries that are done entirely based on indexes were
also _VERY_ slow. But I did a "vacuumdb dbname" as postgres user and after
that thigs were back to normal - very fast.
But I could _NOT_ reproduce this.
Does the number of WAL files have to do anything with this?
On Wed, 25 Apr 2001, Thomas Heller wrote:
> Hi there,
> i just upgraded my database system from 7.0.3 to 7.1 ... i did a
> dumpall and psql -f dump.sql to the new db. the data is in place
> correctly and its running fine. but as soon as i put the connections
> back on to the db the load raised to 6. prior to the upgrade the
> system load was an 0.3 ... now it is at 6.
> is this normal for 7.1 to need so much more hardware? i use the same
> settings for sort_mem, buffers, etc. just no fsync. I thought 7.1
> wouldn't need that anymore.
> Any suggestions that i should do? the performance is really bad now :(
> btw: the db is a dedicated p3-800 + 1gig ram + uw scsi drives running
> thanks cu,
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-admin by date
|Next:||From: Anuradha Ratnaweera||Date: 2001-04-28 12:41:15|
|Subject: Re: Reason to not upgrade from 6.5 to 7.0 or above|
|Previous:||From: Christian Marschalek||Date: 2001-04-27 17:38:39|
|Subject: RE: ODBC connection to PostgreSQL|