Re: OID vs overall system performances on high load

From: PFC
Subject: Re: OID vs overall system performances on high load
Date: ,
Msg-id: op.srhxvgdqth1vuj@localhost
(view: Whole thread, Raw)
In response to: Re: OID vs overall system performances on high load  (Andrew McMillan)
List: pgsql-performance


> The OID column is an extra few bytes on each row.  If you don't have any
> use for it (and let's face it: most of us don't), then create your
> tables "without OID".


    Also there are some useful hacks using the oid which don't work if it
wraps around, thus preventing it from wrapping around by not using on
every table could be useful in some cases...


pgsql-performance by date:

From: PFC
Date:
Subject: Re: OID vs overall system performances on high load
From: Michael Engelhart
Date:
Subject: sequential scan performance