From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | David Johnston <polobo(at)yahoo(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Potential autovacuum optimization: new tables |
Date: | 2012-10-13 02:53:10 |
Message-ID: | 20121013025310.GF29165@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* David Johnston (polobo(at)yahoo(dot)com) wrote:
> Instead of global could you attach an interface function to the table and have the auto-analyzer call that function to basically ask the table whether it needs to be analyzed? Still need to deal with defaults and provide a decent supply of built-in algorithms but at least the system can be made tunable. The default algorithm could maybe just handoff to a table size specific handler. The create table and alter table commands could be used to change the assigned algorithm if desired and new ones could be supplied via extensions.
For my part, while that's certainly an interesting idea, it's far more
complicated than even providing GUCs and the idea is to make PG just "do
it right", not to offer the user more ways to get it wrong...
Thanks,
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Fabrízio de Royes Mello | 2012-10-13 03:56:19 | Re: Adding comments for system table/column names |
Previous Message | Michael Paquier | 2012-10-13 02:50:44 | Re: Support for REINDEX CONCURRENTLY |