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

Re: Interface for pg_autovacuum

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Jim Nasby <jim(dot)nasby(at)enterprisedb(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Dave Page <dpage(at)postgresql(dot)org>, "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Interface for pg_autovacuum
Date: 2006-12-21 18:28:42
Message-ID: 458AD25A.4080000@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
Jim Nasby wrote:
> How about...
>
> ALTER TABLE ...
> ALTER AUTOVACUUM [ THRESHOLD | SCALE | COST DELAY | COST LIMIT ]
> ALTER AUTOANALYZE [ THRESHOLD | SCALE ]


Given these remarks from Tom:

> Where we are currently at is experimenting to find
> out what autovacuum's control knobs ought to be.  The catalog table was
> a suitably low-effort way to expose a first cut at the knobs.

doesn't making language level changes seem more than somewhat premature? 
Or have we finished experimenting?

cheers

andrew

In response to

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2006-12-21 18:29:30
Subject: Re: [HACKERS] Bundle of patches
Previous:From: Teodor SigaevDate: 2006-12-21 18:24:49
Subject: Re: pgsql: Initial SQL/XML support: xml data type and

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