Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id D7CA49FB93F
	for <pgsql-general-postgresql.org@postgresql.org>;
	Sun, 18 Mar 2007 13:55:07 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 40880-08 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Sun, 18 Mar 2007 13:55:00 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from svana.org (unknown [125.62.87.134])
	by postgresql.org (Postfix) with ESMTP id 1F9F59FB78F
	for <pgsql-general@postgresql.org>;
	Sun, 18 Mar 2007 13:55:00 -0300 (ADT)
Received: from kleptog by svana.org with local (Exim 4.50)
	id 1HSyeL-0002zk-Ss; Mon, 19 Mar 2007 03:54:29 +1100
Date: Sun, 18 Mar 2007 17:54:29 +0100
From: Martijn van Oosterhout <kleptog@svana.org>
To: Bruce McAlister <bruce.mcalister@blueface.ie>
Cc: pgsql-general@postgresql.org
Subject: Re: PostgreSQL 8.2.3 VACUUM Timings/Performance
Message-ID: <20070318165429.GD5722@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
Mail-Followup-To: Bruce McAlister <bruce.mcalister@blueface.ie>,
	pgsql-general@postgresql.org
References: <esh2mg$16vu$1@news.hub.org> <19106.1173111068@sss.pgh.pa.us>
	<esrdsb$1klg$1@news.hub.org> <etepst$18fc$1@news.hub.org>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="KdquIMZPjGJQvRdI"
Content-Disposition: inline
In-Reply-To: <etepst$18fc$1@news.hub.org>
X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6
X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522  48A7 6394 F08A 0DC6 7BE6
X-PGP-Key-URL: <http://svana.org/kleptog/0DC67BE6.pgp.asc>
User-Agent: Mutt/1.5.9i
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/1074
X-Sequence-Number: 111263


--KdquIMZPjGJQvRdI
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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 th=
e=20
> pg_autovacuum system tables. However, I'm a little confused as to how I g=
o=20
> about finding out the OID value of the tables. The pg_autovacuum table=20
> requires the OID of the table you want to create settings for (vacrelid).=
=20
> Can anyone shed some light on how I can extract the OID of the table? Als=
o,=20
> what happens if you create a table without OID's, are you still able to a=
dd=20
> it's details in the pg_autovacuum table if there is no OID associated wit=
h a=20
> 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,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to l=
itigate.

--KdquIMZPjGJQvRdI
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFF/W7FIB7bNG8LQkwRAo/pAJ9R8bjRdxiCUZ8BgKN+mcmuDxxkdgCfRWmo
f/Fs1F72U3rUzLzPF4u38Ms=
=n1oX
-----END PGP SIGNATURE-----

--KdquIMZPjGJQvRdI--