Re: autovacuum bootstrap

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)surnet(dot)cl>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autovacuum bootstrap
Date: 2005-06-25 19:52:08
Message-ID: 29008.1119729128@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)surnet(dot)cl> writes:
> I added two new fields to the pg_database flatfile and table, datstats
> and datautovac. They respectively signal the stat collector and
> autovacuum daemon to run for that database.

Why? I can't see a particularly good reason to be able to suppress
these daemons per-database.

> Additionally I need to save some state during initdb for each database,
> and during database creation (and when the hypotetical ALTER DATABASE
> command for turning autovacuum on is executed).

Shouldn't this live in the existing stats collector output file?
Exactly what state have you got in mind?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-06-25 20:30:38 Re: Add PG version number to NLS files
Previous Message Tom Lane 2005-06-25 19:27:51 Fundamental error in "no WAL log" index/file creation stuff