Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3AF1B6325DE for ; Thu, 14 Jan 2010 14:02:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46080-04 for ; Thu, 14 Jan 2010 18:01:59 +0000 (UTC) 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 681F76323AF for ; Thu, 14 Jan 2010 14:01:59 -0400 (AST) Received: from [192.168.1.3] (pool-96-244-14-10.bltmmd.fios.verizon.net [96.244.14.10]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MFwkk-1Nh30Y0NWQ-00Etch; Thu, 14 Jan 2010 19:01:55 +0100 Message-ID: <4B4F5C0E.6050506@2ndquadrant.com> Date: Thu, 14 Jan 2010 13:01:50 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Kevin Grittner CC: Matthew Wakeling , pgsql-performance@postgresql.org Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows References: <4B4EE849020000250002E4A4@gw.wicourts.gov> In-Reply-To: <4B4EE849020000250002E4A4@gw.wicourts.gov> Content-Type: multipart/alternative; boundary="------------020500060906010900050707" X-Provags-ID: V01U2FsdGVkX1/lNwA+ZutbuKIeWsDT0ZRer1wRlX7OogazvCs E7GLQFpksKBBxLeFslIrFrMlYZdxhXqysSLxvgDvxbG4GuWxN2 piDLJnooRF0QXaFppMMYdQKWKpCfQTn X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.59 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201001/291 X-Sequence-Number: 37171 This is a multi-part message in MIME format. --------------020500060906010900050707 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Kevin Grittner wrote: > Matthew Wakeling wrote: > > >> This is an FAQ. >> > > I just added it to the wiki FAQ page: > > http://wiki.postgresql.org/wiki/FAQ#Why_is_.22SELECT_count.28.2A.29_FROM_bigtable.3B.22_slow.3F > The content was already there, just not linked into the main FAQ yet: http://wiki.postgresql.org/wiki/Slow_Counting -- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.com --------------020500060906010900050707 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: 7bit Kevin Grittner wrote:

Matthew Wakeling <matthew@flymine.org> wrote:

This is an FAQ.

 
I just added it to the wiki FAQ page:
 
http://wiki.postgresql.org/wiki/FAQ#Why_is_.22SELECT_count.28.2A.29_FROM_bigtable.3B.22_slow.3F

The content was already there, just not linked into the main FAQ yet: http://wiki.postgresql.org/wiki/Slow_Counting

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com

--------------020500060906010900050707--