X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 46A07D1B4D7; Fri, 16 Jan 2004 22:11:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08046-08; Fri, 16 Jan 2004 18:10:50 -0400 (AST) Received: from linda-2.paradise.net.nz (bm-2a.paradise.net.nz [202.0.58.21]) by svr1.postgresql.org (Postfix) with ESMTP id 2176FD1B4D0; Fri, 16 Jan 2004 18:10:48 -0400 (AST) Received: from smtp-3.paradise.net.nz (smtp-3a.paradise.net.nz [202.0.32.196]) by linda-2.paradise.net.nz (Paradise.net.nz) with ESMTP id <0HRL00NAASA036@linda-2.paradise.net.nz>; Sat, 17 Jan 2004 11:10:49 +1300 (NZDT) Received: from paradise.net.nz (218-101-12-133.paradise.net.nz [218.101.12.133]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id A1173ADF70; Sat, 17 Jan 2004 11:10:48 +1300 (NZDT) Date: Sat, 17 Jan 2004 11:11:33 +1300 From: Mark Kirkwood Subject: Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE In-reply-to: <200401161237.49662.josh@agliodbs.com> To: Josh Berkus Cc: pgsql-performance@postgresql.org, pgsql-general@postgresql.org Message-id: <40086195.4010207@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5) Gecko/20031213 References: <200401161237.49662.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/981 X-Sequence-Number: 56009 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. > > >