Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F07D92E2D37 for ; Thu, 6 Mar 2008 02:54:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 15056-03-4 for ; Thu, 6 Mar 2008 02:54:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.179]) by postgresql.org (Postfix) with ESMTP id 17ACE2E004E for ; Thu, 6 Mar 2008 02:54:42 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu7) with ESMTP (Nemesis) id 0ML2xA-1JXA002ZZd-0004Ew; Thu, 06 Mar 2008 07:54:41 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1JXA00-0005x6-00 for pgsql-performance@postgresql.org; Thu, 06 Mar 2008 07:54:40 +0100 Date: Thu, 6 Mar 2008 07:54:40 +0100 From: "A. Kretschmer" To: pgsql-performance@postgresql.org Subject: Re: count * performance issue Message-ID: <20080306065440.GC21084@a-kretschmer.de> References: <20080306060829.GA21084@a-kretschmer.de> <47CF8EA6.8070503@mark.mielke.cc> <20080306063643.GB21084@a-kretschmer.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/09tfKvm5Fd+TkSvPw2Q37H2kdKDtVZX3Tstm Ue08gebYatiEVpEDBtTUz8GzJE65Wp/G4EjsB3fY4MnSvuiZ2l dC96yIKV3VzGZit1vQ/O4oAGiQuileP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/101 X-Sequence-Number: 29055 am Thu, dem 06.03.2008, um 12:13:17 +0530 mailte sathiya psql folgendes: > is there any way to explicitly force the postgres to use index scan Not realy, PG use a cost-based optimizer and use an INDEX if it make sense. > > On Thu, Mar 6, 2008 at 12:06 PM, A. Kretschmer < > andreas.kretschmer@schollglas.com> wrote: please, no silly top-posting with the complete quote below. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net