disabling OIDs?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: disabling OIDs?
Date: 2004-12-13 02:51:08
Message-ID: 7c1574a904121218516e2989c1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The spam filtering package I use (dspam) had a section in their
release notes recently which stated that disabling OIDs greatly
increased speeds, and so they suggested that people do that on their
tables.

When creating new tables, you can disable OIDs with,
CREATE TABLE foo (...) WITHOUT OIDS;
And you can disable OIDs on existing tables by executing for each table,
ALTER TABLE foo SET WITHOUT OIDS;
and then running a vacuumdb (either with pg_vacuumdb or VACUUM ANALYSE;)

Does anyone know of any risks or potential downsides to doing this?

Thanks!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-12-13 03:16:27 Re: disabling OIDs?
Previous Message Josh Berkus 2004-12-13 02:48:27 Re: Query is not using index when it should