X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 128573A474B for ; Wed, 27 Oct 2004 22:40:57 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14404-07 for ; Wed, 27 Oct 2004 21:40:48 +0000 (GMT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id DA4D13A4758 for ; Wed, 27 Oct 2004 22:40:49 +0100 (BST) Received: (from markw@localhost) by mail.osdl.org (8.11.6/8.11.6) id i9RLem511952; Wed, 27 Oct 2004 14:40:48 -0700 Date: Wed, 27 Oct 2004 14:40:48 -0700 From: Mark Wong To: Josh Berkus Cc: pgsql-performance@postgresql.org, Bjorn Bength Subject: Re: different io elevators in linux Message-ID: <20041027144048.A11433@osdl.org> References: <1098546845.7754.8.camel@localhost> <200410251009.17575.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200410251009.17575.josh@agliodbs.com>; from josh@agliodbs.com on Mon, Oct 25, 2004 at 10:09:17AM -0700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/457 X-Sequence-Number: 8933 On Mon, Oct 25, 2004 at 10:09:17AM -0700, Josh Berkus wrote: > Bjorn, > > > I haven't read much FAQs but has anyone done some benchmarks with > > different io schedulers in linux with postgresql? > > According to OSDL, using the "deadline" scheduler sometimes results in a > roughly 5% boost to performance, and sometimes none, depending on the > application. We use it for all testing, though, just in case. > > --Josh > Yes, we found with an OLTP type workload, the as scheduler performs about 5% worse than the deadline scheduler, where in a DSS type workload there really isn't much difference. The former doing a mix of reading/writing, where the latter is doing mostly reading. Mark