Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE

[Mark Kirkwood]

Along similar lines - have generally obtained better server performance 
(and stability) from most Linux distros after replacing their supplied 
kernel with one from kernel.org .

regards

Mark

Josh Berkus wrote:

Folks,

While debugging a wireless card, I came across this interesting bit:
http://portal.suse.com/sdb/en/2003/10/pohletz_desktop_90.html
What it indicates is that by default SuSE 9.0 plays with the timeslice values 
for the Linux kernel in order to provide a "smoother" user experience.   In 
my experience, this can be very bad news for databases under heavy multi-user 
load.   

I would suggest that anyone installing a SuSE 9.0 PostgreSQL server remove the 
Desktop pararmeter in the bootloader configuration.

 



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster