Irreversible performance drop after increasing shared mem

From: jake(at)omnimode(dot)com (jake johnson)
To: pgsql-general(at)postgresql(dot)org
Subject: Irreversible performance drop after increasing shared mem
Date: 2004-02-24 18:40:30
Message-ID: 8897a0de.0402241040.1db32e2c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running PG 7.4.1 on FreeBSD 5.2.1_RC1 and experienced a general
40% drop in performance after increasing Shared mem buffers to 2000
(from the 1000 default setting) and the Sort Mem to 1024 from 16.
After changing the .conf file back to the original values, performance
didn't change back. Only after dropping the database and reloading
from dump, did performance return. Is this unusual behavior in
anyone's opinion? (Note that I didn't forget to do a pg_ctl reload to
have postmaster re-read the .conf file.)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2004-02-24 18:45:23 Rows to columns
Previous Message Sean Shanny 2004-02-24 18:28:12 Re: Found this in the server log on MAC OSX