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 <andrew@catalyst.net.nz>)
Список 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 по дате отправления:

Предыдущее
От: Andrew McMillan
Дата:
Сообщение: Re: OID vs overall system performances on high load
Следующее
От: Michael Engelhart
Дата:
Сообщение: sequential scan performance