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 A98BFD1B20D for ; Fri, 18 Jun 2004 09:09:37 -0300 (ADT) 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 12692-03 for ; Fri, 18 Jun 2004 12:09:37 +0000 (GMT) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id BF8C1D1B1D0 for ; Fri, 18 Jun 2004 09:09:32 -0300 (ADT) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1BbIBW-0002vU-0b; Fri, 18 Jun 2004 13:09:30 +0100 Date: Fri, 18 Jun 2004 13:09:27 +0100 From: Paul Thomas To: Gary Cowell Cc: pgsql-performance@postgresql.org Subject: Re: Major differences between oracle and postgres performance - what can I do ? Message-ID: <20040618130927.A17585@bacon> References: <20040618113157.84084.qmail@web25104.mail.ukl.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <20040618113157.84084.qmail@web25104.mail.ukl.yahoo.com>; from gary_cowell@yahoo.co.uk on Fri, Jun 18, 2004 at 12:31:57 +0100 X-Mailer: Balsa 1.2.3 Lines: 26 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: 200406/181 X-Sequence-Number: 7239 On 18/06/2004 12:31 Gary Cowell wrote: > [snip] > I'm not as familiar with postgresql as I am with > Oracle but I think I've configured comparible > buffering and sort area sizes, certainly there isn't > much physical IO going on in either case. > > What can I do to speed up this query? Other queries > are slightly slower than under Oracle on the same > hardware but nothing like this. Usual questions: have you vacuumed the table recently? what are your postgresql.conf settings? can you show us explain ANALYZE output rather than just explain output? -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+