Potential Problem with PostgeSQL performance on SuSE Linux 9.0 - Mailing list pgsql-general

From Josh Berkus
Subject Potential Problem with PostgeSQL performance on SuSE Linux 9.0
Date
Msg-id 200401161237.49662.josh@agliodbs.com
Whole thread Raw
Responses Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rich Hall
Date:
Subject: Re: check date validity
Next
From: Bruce Momjian
Date:
Subject: Re: SRF in C