Re: PostgreSQL 8.2.3 VACUUM Timings/Performance

On Fri, Mar 16, 2007 at 07:06:57PM -0000, Bruce McAlister wrote:
> Okay, I'm getting a little further now. I'm about to create entries in the
> pg_autovacuum system tables. However, I'm a little confused as to how I go
> about finding out the OID value of the tables. The pg_autovacuum table
> requires the OID of the table you want to create settings for (vacrelid).
> Can anyone shed some light on how I can extract the OID of the table? Also,
> what happens if you create a table without OID's, are you still able to add
> it's details in the pg_autovacuum table if there is no OID associated with a
> table?

The easiest would seem to be to be:

SELECT 'mytable'::regclass;

That will get you the OID without you having to look it up yourself.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.