Re: disabling OIDs?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: disabling OIDs?
Date: 2004-12-13 06:07:10
Message-ID: 87pt1ewx2p.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Lonni J Friedman <netllama(at)gmail(dot)com> writes:

> OK, thanks. So is there any real benefit in doing this in a generic
> (non-dspam) sense, or is it just a hack that wouldn't be noticable?
> Any risks or potential problems down the line?

OIDs increase the storage requirements so they do slow postgres somewhat.
About (exactly?) the same impact as adding another integer column. That will
have a bigger impact on a narrow table than wider tables.

--
greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2004-12-13 06:16:43 High volume inserts - more disks or more CPUs?
Previous Message Tom Lane 2004-12-13 05:54:12 Re: Temporary tables and disk activity