From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Simple thing to make pg_autovacuum more useful |
Date: | 2008-01-17 21:20:50 |
Message-ID: | 20080117132050.2855baea@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 21:54:47 | Re: Simple thing to make pg_autovacuum more useful |
Previous Message | Tom Lane | 2008-01-17 20:41:30 | Re: Renaming a constraint's index |