From: 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 23:19:09 +0200
Message-ID: <BAY124-W9A86ABFB273675F08F042F5A00@phx.gbl> (raw)
In-Reply-To: <470F9863.EE98.0025.0@wicourts.gov>
References: <BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>
<470F9863.EE98.0025.0@wicourts.gov>
> Do you have autovacuum turned on? With what settings?
Yes, I have it turned on. The settings are:
autovacuum on
autovacuum_analyze_scale_factor 0.1
autovacuum_analyze_threshold 250
autovacuum_freeze_max_age 200000000
autovacuum_naptime 1min
autovacuum_vacuum_cost_delay -1
autovacuum_vacuum_cost_limit -1
autovacuum_vacuum_scale_factor 0.2
autovacuum_vacuum_threshold 500
vacuum_cost_delay 0
vacuum_cost_limit 200
vacuum_cost_page_dirty 20
vacuum_cost_page_hit 1
vacuum_cost_page_miss 10
vacuum_freeze_min_age 100000000
> Do you run scheduled VACUUM ANALYZE?
This too, every night.
> What does the tail of the output from your last
> VACUUM ANALYZE VERBOSE look like?
I'll try to look it up and post it back here once I got it.
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/=
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: henk53602@hotmail.com
Subject: Re: How to speed up min/max(id) in 50M rows table?
In-Reply-To: <BAY124-W9A86ABFB273675F08F042F5A00@phx.gbl>
* 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