Postgres Pro
Downloads
Home   >   mailing lists

Re: How to speed up min/max(id) in 50M rows table? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: How to speed up min/max(id) in 50M rows table?
Date
Msg-id 470F9863.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to How to speed up min/max(id) in 50M rows table?  (henk de wit <henk53602@hotmail.com>)
Responses Re: How to speed up min/max(id) in 50M rows table?
List pgsql-performance
Tree view 
>>> 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

pgsql-performance by date:

Previous
From: henk de wit
Date:
Subject: How to speed up min/max(id) in 50M rows table?
Next
From: henk de wit
Date:
Subject: Re: How to speed up min/max(id) in 50M rows table?