Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 30ABA63290E for ; Thu, 14 Jan 2010 14:34:08 -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 46224-03 for ; Thu, 14 Jan 2010 18:33:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 607DA635319 for ; Thu, 14 Jan 2010 14:33:57 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 14 Jan 2010 12:33:56 -0600 Message-Id: <4B4F0F2F020000250002E4BF@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 14 Jan 2010 12:33:50 -0600 From: "Kevin Grittner" To: "Greg Smith" Cc: "Matthew Wakeling" , 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> In-Reply-To: <4B4F618A.8000807@2ndquadrant.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.476 tagged_above=-10 required=5 tests=AWL=0.123, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201001/299 X-Sequence-Number: 37179 Greg Smith 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? (Of course, it goes without saying that you're welcome to improve upon anything I put in there.) -Kevin