Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 8493C9FBDB9
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 12 Oct 2007 18:19:52 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 87313-07 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 12 Oct 2007 18:19:10 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from bay0-omc2-s8.bay0.hotmail.com (bay0-omc2-s8.bay0.hotmail.com
	[65.54.246.144])
	by postgresql.org (Postfix) with ESMTP id B71E49FBF46
	for <pgsql-performance@postgresql.org>;
	Fri, 12 Oct 2007 18:19:10 -0300 (ADT)
Received: from BAY124-W9 ([207.46.11.172]) by bay0-omc2-s8.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 12 Oct 2007 14:19:09 -0700
Message-ID: <BAY124-W9A86ABFB273675F08F042F5A00@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_b6086ee9-a28d-4268-8f35-ab1a788774d4_"
X-Originating-IP: [86.81.58.36]
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
Importance: Normal
In-Reply-To: <470F9863.EE98.0025.0@wicourts.gov>
References: <BAY124-W503931258D0AE13AF37546F5A00@phx.gbl>
	<470F9863.EE98.0025.0@wicourts.gov>
MIME-Version: 1.0
X-OriginalArrivalTime: 12 Oct 2007 21:19:09.0886 (UTC)
	FILETIME=[878035E0:01C80D15]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/154
X-Sequence-Number: 27176

--_b6086ee9-a28d-4268-8f35-ab1a788774d4_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> Do you have autovacuum turned on?  With what settings?

Yes, I have it turned on. The settings are:

autovacuum     on=20
autovacuum_analyze_scale_factor     0.1
autovacuum_analyze_threshold     250
autovacuum_freeze_max_age     200000000
autovacuum_naptime     1min=20
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/=

--_b6086ee9-a28d-4268-8f35-ab1a788774d4_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'>&gt; Do you have autovacuum turned on?  With what=
 settings?<br><br>Yes, I have it turned on. The settings are:<br><br>autova=
cuum &nbsp;&nbsp;&nbsp; on <br>autovacuum_analyze_scale_factor &nbsp;&nbsp;=
&nbsp; 0.1<br>autovacuum_analyze_threshold &nbsp;&nbsp;&nbsp; 250<br>autova=
cuum_freeze_max_age &nbsp;&nbsp;&nbsp; 200000000<br>autovacuum_naptime &nbs=
p;&nbsp;&nbsp; 1min <br>autovacuum_vacuum_cost_delay &nbsp;&nbsp;&nbsp; -1<=
br>autovacuum_vacuum_cost_limit &nbsp;&nbsp;&nbsp; -1<br>autovacuum_vacuum_=
scale_factor &nbsp;&nbsp;&nbsp; 0.2<br>autovacuum_vacuum_threshold &nbsp;&n=
bsp;&nbsp; 500<br>vacuum_cost_delay &nbsp;&nbsp;&nbsp; 0<br>vacuum_cost_lim=
it &nbsp;&nbsp;&nbsp; 200<br>vacuum_cost_page_dirty &nbsp;&nbsp;&nbsp; 20<b=
r>vacuum_cost_page_hit &nbsp;&nbsp;&nbsp; 1<br>vacuum_cost_page_miss &nbsp;=
&nbsp;&nbsp; 10<br>vacuum_freeze_min_age &nbsp;&nbsp;&nbsp; 100000000<br><b=
r>&gt; Do you run scheduled VACUUM ANALYZE?<br><br>This too, every night.<b=
r><br>&gt; What does the tail of the output from your last<br>&gt; VACUUM A=
NALYZE VERBOSE look like?<br><br>I'll try to look it up and post it back he=
re once I got it.<br><br /><hr />Express yourself instantly with MSN Messen=
ger! <a href=3D'http://clk.atdmt.com/AVE/go/onm00200471ave/direct/01/' targ=
et=3D'_new'>MSN Messenger</a></body>
</html>=

--_b6086ee9-a28d-4268-8f35-ab1a788774d4_--