X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 77057D1B524 for ; Sun, 28 Sep 2003 16:54:49 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 82147-10 for ; Sun, 28 Sep 2003 13:54:19 -0300 (ADT) Received: from boats_exch01.boats.com (h209-17-182-106.gtconnect.net [209.17.182.106]) by svr1.postgresql.org (Postfix) with ESMTP id 4288DD1B503 for ; Sun, 28 Sep 2003 13:54:18 -0300 (ADT) Received: by BOATS_EXCH01 with Internet Mail Service (5.5.2653.19) id ; Sun, 28 Sep 2003 09:52:54 -0700 Received: from GRIFFITHS2 ([192.168.12.207]) by boats_exch01.boats.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id TTY6TJTP; Sun, 28 Sep 2003 09:52:45 -0700 From: David Griffiths To: pgsql-general@postgresql.org Message-ID: <008d01c385e2$463b4b60$6501a8c0@griffiths2> References: <01d201c38573$84606930$6501a8c0@griffiths2> <9442.1064765602@sss.pgh.pa.us> Subject: Re: Tuning/performance question. Date: Sun, 28 Sep 2003 10:02:13 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4922.1500 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/1741 X-Sequence-Number: 49960 > David, could we see EXPLAIN ANALYZE for the query, and also the table > schemas (psql \d displays would do)? Also, please take it to > pgsql-performance, it's not really on-topic for pgsql-general. > > regards, tom lane Will do. Thanks, David.