X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id C0B3E3103AA for ; Sat, 28 Jun 2003 11:58:29 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 73105-10 for ; Sat, 28 Jun 2003 08:58:19 -0300 (ADT) Received: from mailhost3.tudelft.nl (mailhost3.tudelft.nl [130.161.180.83]) by svr1.postgresql.org (Postfix) with ESMTP id 6150C31044F for ; Sat, 28 Jun 2003 08:58:18 -0300 (ADT) Received: from 127.0.0.1 (localhost [127.0.0.1]) by rav.antivirus (Postfix) with SMTP id 41E40479; Sat, 28 Jun 2003 13:58:18 +0200 (MEST) Received: from listserv.tudelft.nl (listserv.tudelft.nl [130.161.180.33]) by mailhost3.tudelft.nl (Postfix) with ESMTP id 77F1D464; Sat, 28 Jun 2003 13:58:17 +0200 (MEST) Received: from acm (x193056-2.shuis-s.tudelft.nl [145.94.193.58]) by listserv.tudelft.nl (8.12.8p1/8.12.8) with ESMTP id h5SBvtDb006297; Sat, 28 Jun 2003 13:58:16 +0200 (MEST) From: "Arjen van der Meijden" To: , Subject: Re: 'best practises' to speed up sorting? tuning postgresql.conf Date: Sat, 28 Jun 2003 13:58:09 +0200 Message-ID: <001001c33d6c$9590c140$3ac15e91@acm> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Archive-Number: 200306/204 X-Sequence-Number: 2288 > Chris Hutchinson wrote: > I'm wondering how to speed up sorting which is slowing a > query run regularly on a linux postgresql 7.3.3 system. I see a lot of seq scans in your explain and there are no index scans, have you done a 'vacuum analyze' lately? Arjen