Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B97F52E02F0 for ; Mon, 10 Mar 2008 18:52:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20370-02-2 for ; Mon, 10 Mar 2008 18:52:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id DBA552E02DB for ; Mon, 10 Mar 2008 18:52:43 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m2ALqexp012711; Mon, 10 Mar 2008 17:52:40 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m2ALqeF0012705; Mon, 10 Mar 2008 17:52:40 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Mon, 10 Mar 2008 17:52:40 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com cc: Joe Mirabal , pgsql-performance@postgresql.org Subject: Re: count * performance issue In-Reply-To: <20080310172826.da1cafd1.wmoran@collaborativefusion.com> Message-ID: References: <47D00DB2.7040007@emolecules.com> <18451.1204824562@sss.pgh.pa.us> <200803071727.36146.josh@agliodbs.com> <13345.1204940295@sss.pgh.pa.us> <87r6eia9tz.fsf@oxford.xeocode.com> <12ba3bf00803101354w15b023e1o237f564a1b01105f@mail.gmail.com> <20080310172826.da1cafd1.wmoran@collaborativefusion.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.147 tagged_above=0 required=5 tests=AWL=-1.434, MISSING_HEADERS=1.581 X-Spam-Level: X-Archive-Number: 200803/208 X-Sequence-Number: 29162 On Mon, 10 Mar 2008, Bill Moran wrote: > Some searches through the archives should turn up details on these > methods. I've collected up what looked like the best resources on this topic into the FAQ entry at http://www.postgresqldocs.org/index.php/Slow_Count General Bits has already done two good summary articles here and I'd think wading through the archives directly shouldn't be necessary. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD