Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id A7F559FB442
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  8 Oct 2006 22:14:07 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 16211-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun,  8 Oct 2006 22:14:05 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 83C229FB3D0
	for <pgsql-performance@postgresql.org>;
	Sun,  8 Oct 2006 22:14:03 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr4.postgresql.org (Postfix) with ESMTP id 3EF805AFA73
	for <pgsql-performance@postgresql.org>;
	Sun,  8 Oct 2006 23:16:42 +0000 (GMT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k98NGbka012916;
	Sun, 8 Oct 2006 19:16:37 -0400 (EDT)
To: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org,
	"Denis Lussier" <denisl@enterprisedb.com>,
	"Bruce Momjian" <bruce@momjian.us>,
	"korryd@enterprisedb.com" <korryd@enterprisedb.com>,
	"Jonah H. Harris" <jharris@enterprisedb.com>,
	"Craig A. James" <cjames@modgraph-usa.com>
Subject: Re: Simple join optimized badly? 
In-reply-to: <200610081605.03501.josh@agliodbs.com> 
References: <45274A77.7080005@modgraph-usa.com>
	<18722.1160236300@sss.pgh.pa.us>
	<5f820f750610071850o6ed0b19o162d65d1987b2a8c@mail.gmail.com>
	<200610081605.03501.josh@agliodbs.com>
Comments: In-reply-to Josh Berkus <josh@agliodbs.com>
	message dated "Sun, 08 Oct 2006 16:05:02 -0700"
Date: Sun, 08 Oct 2006 19:16:37 -0400
Message-ID: <12915.1160349397@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.663 tagged_above=0 required=5 tests=AWL, SPF_FAIL
X-Spam-Level: 
X-Archive-Number: 200610/145
X-Sequence-Number: 21274

Josh Berkus <josh@agliodbs.com> writes:
> Now, if you were offering us a patch to auto-populate the statistics as a 
> table is loaded, I'd be all for that.

Curiously enough, I was just thinking about that after reading Craig's
post.  autovacuum will do this, sort of, if it's turned on --- but its
reaction time is measured in minutes typically so that may not be good
enough.

Another thing we've been beat up about in the past is that loading a
pg_dump script doesn't ANALYZE the data afterward...

			regards, tom lane