Re: Potential autovacuum optimization: new tables - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Potential autovacuum optimization: new tables
Date
Msg-id 20121013012533.GD29165@tamriel.snowman.net
Whole thread Raw
In response to Re: Potential autovacuum optimization: new tables  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
* Josh Berkus (josh@agliodbs.com) wrote:
> Because Snowman asked me for an example:

Thanks. :)

> That's a 25X difference in execution time.  This is not the first time
> I've seen this issue.

If we can figure out an 'easy' solution to this, I'd definitely vote for
it being back-patched.  Having a table simply never get analyze'd
strikes me as a very bad thing.
Thanks again,
    Stephen

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Potential autovacuum optimization: new tables
Next
From: Josh Berkus
Date:
Subject: Re: Potential autovacuum optimization: new tables