Re: PostgreSQL 8.2.3 VACUUM Timings/Performance

From: Erik Jones <erik(at)myemma(dot)com>
To: "Bruce McAlister" <bruce(dot)mcalister(at)blueface(dot)ie>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance
Date: 2007-03-16 19:22:04
Message-ID: 9C177C36-6024-4952-ABE5-5E636A8BF02F@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On Mar 16, 2007, at 2:06 PM, Bruce McAlister wrote:

> Hi All,
>
> 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?

SELECT oid FROM pg_class where relname='table_name';

The WITH/WITHOUT OIDS clause of CREATE TABLE refers to whether or not
to create oids for the rows of the table, not the table it itself.
Tables always get an oid.

erik jones <erik(at)myemma(dot)com>
software developer
615-296-0838
emma(r)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2007-03-16 19:40:17 Oracle-PostgreSQL Coexistence/Interoperability (segue from PostgreSQL to Oracle)
Previous Message Kacper Chrapa 2007-03-16 19:19:41 Own messages for constraints?

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2007-03-17 04:52:39 Re: Postgres batch write very slow - what to do
Previous Message Bruce McAlister 2007-03-16 19:06:57 Re: PostgreSQL 8.2.3 VACUUM Timings/Performance