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

Re: Interface for pg_autovacuum

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: Jim Nasby <jim(dot)nasby(at)enterprisedb(dot)com>
Cc: PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Interface for pg_autovacuum
Date: 2006-12-20 12:56:27
Message-ID: 458932FB.6030105@phlo.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Jim Nasby wrote:
> I'm teaching a class this week and a student asked me about OIDs. He 
> related the story of how in Sybase, if you moved a database from one 
> server from another, permissions got all screwed up because user IDs no 
> longer matched. I explained that exposing something like an integer ID 
> in a user interface or an API is just a bad idea and PostgreSQL doesn't 
> do that.
> 
> Then I got to pg_autovacuum....
> 
> So... is there any reason there isn't a prescribed interface to 
> pg_autovacuum that doesn't expose vacrelid? Can we get that added to TODO?

Wouldn't it be sufficient to change the type of vacrelid from oid
to regclass? Then just dumping and restoring pg_autovacuum like any
other table should Just Work.

greetings, Florian Pflug

In response to

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2006-12-20 13:17:49
Subject: VS: Companies Contributing to Open Source
Previous:From: Felipe Rondon RochaDate: 2006-12-20 12:43:52
Subject: Fw: Fw: choosing use an index or not

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