From: Greg Smith <greg@2ndquadrant.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Matthew Wakeling <matthew@flymine.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
Date: Thu, 14 Jan 2010 13:25:14 -0500
Message-ID: <4B4F618A.8000807@2ndquadrant.com> (raw)
In-Reply-To: <4B4F0A21020000250002E4B8@gw.wicourts.gov>
References: <4B4EE849020000250002E4A4@gw.wicourts.gov>
<4B4F5C0E.6050506@2ndquadrant.com>
<4B4F0A21020000250002E4B8@gw.wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, Kevin.Grittner@wicourts.gov, matthew@flymine.org
Subject: Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
In-Reply-To: <4B4F618A.8000807@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox