Re: [GENERAL] Irreversible performance drop after increasing shared mem

2004-02-28 Thread Martijn van Oosterhout
On Tue, Feb 24, 2004 at 10:40:30AM -0800, jake johnson wrote: > 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 f

[GENERAL] Irreversible performance drop after increasing shared mem

2004-02-28 Thread jake johnson
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