Re: disabling OIDs? - Mailing list pgsql-general

From Greg Stark
Subject Re: disabling OIDs?
Date
Msg-id 87pt1ewx2p.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: disabling OIDs?  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-general
Lonni J Friedman <netllama@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Temporary tables and disk activity
Next
From: "Guy Rouillier"
Date:
Subject: High volume inserts - more disks or more CPUs?