Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A194C64FD47 for ; Sun, 23 Nov 2008 08:41:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10231-05 for ; Sun, 23 Nov 2008 08:41:11 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 8718564FC5C for ; Sun, 23 Nov 2008 08:41:11 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id mANCf6Bn030435 for ; Sun, 23 Nov 2008 08:41:06 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id mANCLRvu011510 for pgsql-performance@postgresql.org; Sun, 23 Nov 2008 08:21:27 -0400 (AST) (envelope-from news) From: "Andrus" X-Newsgroups: pgsql.performance Subject: Re: seq scan over 3.3 million rows instead of single keyindex access Date: Sun, 23 Nov 2008 13:43:08 +0200 Organization: Hub.Org Networking Services Lines: 7 Message-ID: References: <20081123081024.GA7443@tux> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org In-Reply-To: <20081123081024.GA7443@tux> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6001.18000 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200811/216 X-Sequence-Number: 31947 > An index-scan makes only sense if rid contains considerable more than > 3000000 rows. I'm sorry, I meant using index to get the row. Andrus.