Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id E0139633D82
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 14:50:15 -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 48958-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 14 Jan 2010 18:50:02 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8])
	by mail.postgresql.org (Postfix) with ESMTP id C1C2B6325F4
	for <pgsql-performance@postgresql.org>;
	Thu, 14 Jan 2010 14:50:04 -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=mrbap2) with ESMTP (Nemesis)
	id 0Lo2Ke-1O73ZX286K-00ftb4; Thu, 14 Jan 2010 19:50:00 +0100
Message-ID: <4B4F6756.3080105@2ndquadrant.com>
Date: Thu, 14 Jan 2010 13:49:58 -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>
	<4B4F618A.8000807@2ndquadrant.com>
	<4B4F0F2F020000250002E4BF@gw.wicourts.gov>
In-Reply-To: <4B4F0F2F020000250002E4BF@gw.wicourts.gov>
Content-Type: multipart/alternative;
	boundary="------------080803050402070502090406"
X-Provags-ID: V01U2FsdGVkX1+tXlpIGAquTdaKeQSUof1i84J86IuMHd3wIEe
	IwJqHez78CvhilU24HnP6O0onzqYnV8nu01lVGq1V45Z4X90y7
	9qrEOqqKMo6T1q18xOLgyg1oX/HDiYw
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.427 tagged_above=-10 required=5 tests=AWL=0.171,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201001/300
X-Sequence-Number: 37180

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

Kevin Grittner wrote:
> Greg Smith <greg@2ndquadrant.com> wrote:
>  
>   
>> 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.
>>     
>  
> Well, unless you object to the way I did it, there's one down. 
> Should I remove it from the list of "Other FAQs" on the page you
> cite?
>  

Sure; everyone should feel free to assimilate into the main FAQ and wipe 
out anything on that smaller list. Those are mainly topics where the 
discussion of workarounds and approaches can be much longer than 
standard FAQ length, so I suspect many of the answers are going to be a 
very brief summary with a link to longer discussion. If you come across 
a really small one, we might even wipe out the original page once it's 
merged in.

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


--------------080803050402070502090406
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:4B4F0F2F020000250002E4BF@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="">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 
<a class="moz-txt-link-freetext" href="http://wiki.postgresql.org/wiki/Frequently_Asked_Questions">http://wiki.postgresql.org/wiki/Frequently_Asked_Questions</a>

I just haven't had time to merge those all usefully into the main
FAQ.
    </pre>
  </blockquote>
  <pre wrap=""><!----> 
Well, unless you object to the way I did it, there's one down. 
Should I remove it from the list of "Other FAQs" on the page you
cite?
 </pre>
</blockquote>
<br>
Sure; everyone should feel free to assimilate into the main FAQ and
wipe out anything on that smaller list.&nbsp; Those are mainly topics where
the discussion of workarounds and approaches can be much longer than
standard FAQ length, so I suspect many of the answers are going to be a
very brief summary with a link to longer discussion.&nbsp; If you come
across a really small one, we might even wipe out the original page
once it's merged in.<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>

--------------080803050402070502090406--