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 2F04AD1B8B4 for ; Thu, 4 Sep 2003 01:03:35 +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 65565-09 for ; Wed, 3 Sep 2003 22:03:06 -0300 (ADT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by svr1.postgresql.org (Postfix) with ESMTP id C0717D1B89E for ; Wed, 3 Sep 2003 22:02:59 -0300 (ADT) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id LAA14495; Thu, 4 Sep 2003 11:31:29 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3F569012.3090209@oasis.net.au> Date: Thu, 04 Sep 2003 11:06:26 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Relaxin Cc: pgsql-performance@postgresql.org Subject: Re: SELECT's take a long time compared to other DBMS References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/38 X-Sequence-Number: 3404 Hi, >And yes I did a vacuum. > Did you 'Analyze' too ? Cheers Rudi.