Re: pg_autovacuum entries - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: pg_autovacuum entries
Date
Msg-id 20091030230446.GI4003@alvh.no-ip.org
Whole thread Raw
In response to pg_autovacuum entries  (Anj Adu <fotographs@gmail.com>)
Responses Re: pg_autovacuum entries
List pgsql-admin
Anj Adu escribió:

> Is there a way to create an entry for a table that does not exist yet?

No, you will have to have "INSERT INTO pg_autovacuum" statements
alongside your table creation.  I don't see that this is a lot of
trouble though, you can simply do

CREATE TABLE whatever ( ... );
INSERT INTO pg_autovacuum VALUES ('whatever'::regclass, false, -1, -1, ...);

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: pg_autovacuum entries
Next
From: "saturon"
Date:
Subject: Consistent EC2 Snapshots with Postgres