Skip site navigation (1) Skip section navigation (2)

Potential Problem with PostgeSQL performance on SuSE Linux 9.0

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Potential Problem with PostgeSQL performance on SuSE Linux 9.0
Date: 2004-01-16 20:37:49
Message-ID: 200401161237.49662.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2004-01-16 22:11:33
Subject: Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE
Previous:From: Tom LaneDate: 2004-01-16 19:26:18
Subject: Re: Question about space usage:

pgsql-general by date

Next:From: Bruce MomjianDate: 2004-01-16 20:50:58
Subject: Re: SRF in C
Previous:From: D. Dante LorensoDate: 2004-01-16 20:27:57
Subject: User-specific sequences

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group