Re: OID vs overall system performances on high load

От: PFC
Тема: Re: OID vs overall system performances on high load
Дата: ,
Msg-id: op.srhxvgdqth1vuj@localhost
(см: обсуждение, исходный текст)
Ответ на: Re: OID vs overall system performances on high load  (Andrew McMillan)
Список: 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 по дате сообщения:

От: PFC
Дата:
Сообщение: Re: OID vs overall system performances on high load
От: Michael Engelhart
Дата:
Сообщение: sequential scan performance