Re: How to speed up min/max(id) in 50M rows table?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "henk de wit" <henk53602(at)hotmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to speed up min/max(id) in 50M rows table?
Date: 2007-10-12 20:53:07
Message-ID: 470F9863.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>> On Fri, Oct 12, 2007 at 3:41 PM, in message
<BAY124-W503931258D0AE13AF37546F5A00(at)phx(dot)gbl>, henk de wit
<henk53602(at)hotmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message henk de wit 2007-10-12 20:59:52 Re: How to speed up min/max(id) in 50M rows table?
Previous Message henk de wit 2007-10-12 20:41:56 How to speed up min/max(id) in 50M rows table?