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?
Anuradha
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
> redhat6.2
>
> thanks cu,
> thomas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>