Skip site navigation (1) Skip section navigation (2)

Simple thing to make pg_autovacuum more useful

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 (view raw or flat)
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-----

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-01-17 21:54:47
Subject: Re: Simple thing to make pg_autovacuum more useful
Previous:From: Tom LaneDate: 2008-01-17 20:41:30
Subject: Re: Renaming a constraint's index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group