Thread: Potential Problem with PostgeSQL performance on SuSE Linux 9.0
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. -- Josh Berkus Aglio Database Solutions San Francisco
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. > > >