Re: Simple join optimized badly? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Simple join optimized badly?
Date
Msg-id 12915.1160349397@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple join optimized badly?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Craig A. James"
Date:
Subject: Re: Simple join optimized badly?
Next
From: Bruce Momjian
Date:
Subject: Re: Simple join optimized badly?