From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: henk de wit <henk53602@hotmail.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: How to speed up min/max(id) in 50M rows table?
Date: Fri, 12 Oct 2007 15:53:07 -0500
Message-ID: <470F9863.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>
References: <BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>
>>> On Fri, Oct 12, 2007 at 3:41 PM, in message
<BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>, henk de wit
<henk53602@hotmail.com> wrote:
>
> I have a table with some 50 millions rows in PG 8.2. The table has indexes
> on relevant columns. My problem is that most everything I do with this table
> (which are actually very basic selects) is unbearable slow.
Do you have autovacuum turned on? With what settings?
Do you run scheduled VACUUM ANALYZE?
What does the tail of the output from your last
VACUUM ANALYZE VERBOSE look like?
-Kevin
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: Kevin.Grittner@wicourts.gov, henk53602@hotmail.com
Subject: Re: How to speed up min/max(id) in 50M rows table?
In-Reply-To: <470F9863.EE98.0025.0@wicourts.gov>
* 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