From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
---|---|
To: | "'Thomas Heller'" <maniax(at)comtron(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | RE: 7.1 performance |
Date: | 2001-04-26 15:54:12 |
Message-ID: | 8F4C99C66D04D4118F580090272A7A234D33D3@sectorbase1.sectorbase.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 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.
7.1 requires fsync! fsync-s are just much more optimized there.
> Any suggestions that i should do? the performance is really bad now :(
What kind of queries have bad performance now?
For insert/update/delete queries you could consider increasing
wal_buffers (~256) and wal_files (~16).
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-26 16:16:49 | Re: error compiling 7.1 on Solaris 8 x86 (long) |
Previous Message | J.H.M. Dassen Ray | 2001-04-26 15:49:14 | Re: error compiling 7.1 on Solaris 8 x86 (long) |