Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6A64F9FB334 for ; Tue, 3 Oct 2006 09:17:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 14298-04-6 for ; Tue, 3 Oct 2006 09:17:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lynet.oppetid.no (oppetid.no [80.65.51.2]) by postgresql.org (Postfix) with ESMTP id 1762F9FB2EA for ; Tue, 3 Oct 2006 09:17:12 -0300 (ADT) Received: by lynet.oppetid.no (Postfix, from userid 1019) id F37B111AFB4; Tue, 3 Oct 2006 14:17:09 +0200 (CEST) Date: Tue, 3 Oct 2006 14:17:09 +0200 From: Tobias Brox To: Arnaud Lesauvage Cc: Tobias Brox , pgsql-performance@postgresql.org Subject: Re: Poor performance on very simple query ? Message-ID: <20061003121709.GF30211@oppetid.no> References: <45224896.7040708@freesurf.fr> <20061003121004.GC30211@oppetid.no> <20061003121109.GD30211@oppetid.no> <45225407.7090805@freesurf.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45225407.7090805@freesurf.fr> Organization: Group Nordicbet User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.18 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/36 X-Sequence-Number: 21165 [Arnaud Lesauvage - Tue at 02:13:59PM +0200] > Tobias Brox wrote: > >Oh, the gid is not primary key. I guess I should also apologize for > >adding noise here :-) > > Yes, it is a primary key, but I am the noise maker here ! ;-) Oh - it is. How can you have a default value on a primary key? Will it use the index if you do "analyze"? Is there an index on the table at all, do you get it up if you ask for a description of the table (\d tablename)?