| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-01-16 20:50:58 | Re: SRF in C |
| Previous Message | D. Dante Lorenso | 2004-01-16 20:27:57 | User-specific sequences |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2004-01-16 22:11:33 | Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE |
| Previous Message | Tom Lane | 2004-01-16 19:26:18 | Re: Question about space usage: |