-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello,
Table "pg_catalog.pg_autovacuum" Column | Type | Modifiers - ------------------+---------+----------- vacrelid | oid | not null enabled | boolean | not null vac_base_thresh | integer | not null vac_scale_factor | real | not null anl_base_thresh | integer | not null anl_scale_factor | real | not null vac_cost_delay | integer | not null vac_cost_limit | integer | not null freeze_min_age | integer | not null freeze_max_age | integer | not null Can we by default set vac_cost_limit and vac_cost_delay have a DEFAULT - -1? That way by default it will use the settings in postgresql.conf? Secondly can we set the default for freeze_min_age to 100mil (I think that is the default in the docs) and freeize_max_age to the default 200000000 . In the environments we manage we are using pg_autovacuum alot in order to manage individual relations. This is probably too late for 8.3 :( but it should would make our lives easier. Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHj8ayATb/zqfZUUQRAjHqAJ0bkc/ik4mZ0JldO6NLLjDKDDvLogCgqCK6 er+zFTHiFO1Fbi/BXzkWCqA= =7swT -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq