X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 55B2CD1B52C for ; Wed, 3 Sep 2003 14:39:42 +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 08440-01 for ; Wed, 3 Sep 2003 11:39:35 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5FBFAD1BA5E for ; Wed, 3 Sep 2003 11:39:31 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h83EdZjX014503; Wed, 3 Sep 2003 10:39:35 -0400 (EDT) To: Azlin Ghazali Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL is slow...HELP In-reply-to: <20030903130857.5986.qmail@web40401.mail.yahoo.com> References: <20030903130857.5986.qmail@web40401.mail.yahoo.com> Comments: In-reply-to Azlin Ghazali message dated "Wed, 03 Sep 2003 06:08:57 -0700" Date: Wed, 03 Sep 2003 10:39:35 -0400 Message-ID: <14502.1062599975@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/20 X-Sequence-Number: 3386 Azlin Ghazali writes: > Below is the exact statement I used: That's not very informative. Could we see the results of EXPLAIN ANALYZE on that SELECT? Also, what PG version are you running? regards, tom lane