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:49:58 -0500
Message-ID: <4B4F6756.3080105@2ndquadrant.com> (raw)
In-Reply-To: <4B4F0F2F020000250002E4BF@gw.wicourts.gov>
References: <4B4EE849020000250002E4A4@gw.wicourts.gov>
<4B4F5C0E.6050506@2ndquadrant.com>
<4B4F0A21020000250002E4B8@gw.wicourts.gov>
<4B4F618A.8000807@2ndquadrant.com>
<4B4F0F2F020000250002E4BF@gw.wicourts.gov>
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
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: <4B4F6756.3080105@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