Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CC3BE64FDBF for ; Sun, 23 Nov 2008 08:20:19 -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 06877-08 for ; Sun, 23 Nov 2008 08:20:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by mail.postgresql.org (Postfix) with ESMTP id C5B5464FDB3 for ; Sun, 23 Nov 2008 08:20:15 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1L4Dwi14RG-00086s; Sun, 23 Nov 2008 13:20:13 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1L4Dwh-0005if-00 for pgsql-performance@postgresql.org; Sun, 23 Nov 2008 13:20:11 +0100 Date: Sun, 23 Nov 2008 13:20:11 +0100 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: seq scan over 3.3 million rows instead of single key index access Message-ID: <20081123122011.GA21619@a-kretschmer.de> References: <87k5avz7l5.fsf@oxford.xeocode.com> <3D5FFE56C89B4D55956907DD7C712F42@andrusnotebook> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3D5FFE56C89B4D55956907DD7C712F42@andrusnotebook> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19q9sGDMt0BtLrhJavEnxcZdICrQJSNEogoz89 tN39qGmC8NppGy4uyJ4O6u+iVsqAKFj7Epk97lLNoV244ps4Lt qvT9oBguw3dOVNS43EvFxFilo514iGB X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200811/215 X-Sequence-Number: 31946 am Sun, dem 23.11.2008, um 6:20:08 +0200 mailte Andrus folgendes: > Gregory, > > > I would suggest running ANALYZE > >idtellUued at some point before the problematic query. > > Thank you. > After adding analyze all is OK. > Is analyze command required in 8.3 also ? Yes. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net