Thread: Potential Problem with PostgeSQL performance on SuSE Linux 9.0

Potential Problem with PostgeSQL performance on SuSE Linux 9.0

From
Josh Berkus
Date:
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

Re: Potential Problem with PostgeSQL performance on SuSE

From
Mark Kirkwood
Date:
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.
>
>
>


Re: Potential Problem with PostgeSQL performance on SuSE

From
Josh Berkus
Date:
Mark,

> 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 .

Hmmm.... any anecdotes about replacing Red Hat 2.4.18 to .24?  I've been
having problems I can't track down on that platform ...

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


Re: Potential Problem with PostgeSQL performance on SuSE

From
Mark Kirkwood
Date:
We use a server at work that is patched RH 7.3 / 2.4.18 with 2.4.21 (or
thereabouts its < .24).

We have stability issues with Java 1.4 / Tomcat 4.1 but not Pg.

It might even be worth building yourself a vanilla 2.4.18 kernel and
seeing if that makes any difference...

regards

Mark


Josh Berkus wrote:

>Mark,
>
>
>
>>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 .
>>
>>
>
>Hmmm.... any anecdotes about replacing Red Hat 2.4.18 to .24?  I've been
>having problems I can't track down on that platform ...
>
>
>