From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Autovacuum in the backend |
Date: | 2005-06-15 17:01:31 |
Message-ID: | 200506151001.31369.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Qingqing,
> add a parameter to let user pass in the configuration parameters:
> * autovacuum_command = "-s 100 -S 1 ..."
um, can we have these as separate GUCs and not lumped together as a string?
i.e.:
autovacuum_frequency = 60 #seconds, 0 = disable
autovacuum_vacuum_threshold = 200
autovacuum_vacuum_multiple = 0.5
autovacuum_analyze_threshold = 100
autovacuum_analyze_multiple = 0.4
AV should be disabled by default. It should also automatically use the global
vacuum_delay settings.
> But it would be very nice to have something _similar_ to FSM, say DSM
> (dead space map), which is filled in when a tuple is marked as "dead for
> all running backends", which could be used to implement a vacuum which
> vacuums only those pages, which do actually contain removable tuples.
Speaking of FSM improvements, it would be **really** useful to have a pg_stats
view that let you know how full the FSM was, overall. something like:
pg_stats_fsm_usage
fsm_relations fsm_relations_used fsm_pages fsm_pages_used
1000 312 200000 11579
This would allow for other schemes of vacuum automation.
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Miller | 2005-06-15 17:01:58 | Re: enebling regular user to create new users ? |
Previous Message | Alvaro Herrera | 2005-06-15 16:58:25 | Re: Current transaction ID? |
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2005-06-15 17:56:39 | max_fsm_pages >800k ... ? |
Previous Message | Josh Berkus | 2005-06-15 16:51:07 | Re: LGPL |