Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 82DF163341E
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 14:25:36 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 44623-06
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 18:25:23 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9])
	by mail.postgresql.org (Postfix) with ESMTP id 4C3CF632601
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 14:25:21 -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=mrbap0) with ESMTP (Nemesis)
	id 0MTePA-1NMaRn3iqm-00R05p; Thu, 14 Jan 2010 19:25:17 +0100
Message-ID: <4B4F618A.8000807@2ndquadrant.com>
Date: Thu, 14 Jan 2010 13:25:14 -0500
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: Matthew Wakeling <matthew@flymine.org>, pgsql-performance@postgresql.org
Subject: Re: Slow "Select count(*) ..." query on table with		 60
 Mio. rows
References: <4B4EE849020000250002E4A4@gw.wicourts.gov>
	<4B4F5C0E.6050506@2ndquadrant.com>
	<4B4F0A21020000250002E4B8@gw.wicourts.gov>
In-Reply-To: <4B4F0A21020000250002E4B8@gw.wicourts.gov>
Content-Type: multipart/alternative;
	boundary="------------000705090606000707040909"
X-Provags-ID: V01U2FsdGVkX19aA6ZaFFjOfvmMxEiZLVUhOzUK1nhb4nO7mDm
	akPcIg0WWQY+QOkGq3PMfHQkj+UhVF2pSvRS1rmRGtexjQ0SQ0
	jqajuWtD8ej80GtahFxyu9F6WPhvTaB
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.425 tagged_above=-10 required=5 tests=AWL=0.173,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/296
X-Sequence-Number: 37176

This is a multi-part message in MIME format.
--------------000705090606000707040909
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit

Kevin Grittner wrote:
> Greg Smith <greg@2ndquadrant.com> wrote:
>  
>   
>> The content was already there, just not linked into the main FAQ
>> yet: 
>> http://wiki.postgresql.org/wiki/Slow_Counting
>>     
>  
> For a question asked this frequently, it should probably be in the
> FAQ.  I'll add a link from there to the more thorough write-up.
>  

There's a whole list of FAQs that are documented on the wiki but not in 
the main FAQ yet leftover from before the main FAQ was hosted there. You 
can see them all at 
http://wiki.postgresql.org/wiki/Frequently_Asked_Questions

I just haven't had time to merge those all usefully into the main FAQ.

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


--------------000705090606000707040909
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=US-ASCII" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Kevin Grittner wrote:
<blockquote cite="mid:4B4F0A21020000250002E4B8@gw.wicourts.gov"
 type="cite">
  <pre wrap="">Greg Smith <a class="moz-txt-link-rfc2396E" href="mailto:greg@2ndquadrant.com">&lt;greg@2ndquadrant.com&gt;</a> wrote:
 
  </pre>
  <blockquote type="cite">
    <pre wrap="">The content was already there, just not linked into the main FAQ
yet: 
<a class="moz-txt-link-freetext" href="http://wiki.postgresql.org/wiki/Slow_Counting">http://wiki.postgresql.org/wiki/Slow_Counting</a>
    </pre>
  </blockquote>
  <pre wrap=""><!----> 
For a question asked this frequently, it should probably be in the
FAQ.  I'll add a link from there to the more thorough write-up.
 </pre>
</blockquote>
<br>
There's a whole list of FAQs that are documented on the wiki but not in
the main FAQ yet leftover from before the main FAQ was hosted there.&nbsp;
You can see them all at
<a class="moz-txt-link-freetext" href="http://wiki.postgresql.org/wiki/Frequently_Asked_Questions">http://wiki.postgresql.org/wiki/Frequently_Asked_Questions</a> <br>
<br>
I just haven't had time to merge those all usefully into the main FAQ.<br>
<br>
<pre class="moz-signature" cols="72">-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
<a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a>  <a class="moz-txt-link-abbreviated" href="http://www.2ndQuadrant.com">www.2ndQuadrant.com</a>
</pre>
</body>
</html>

--------------000705090606000707040909--