Re: disabling OIDs?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: disabling OIDs?
Дата
Msg-id 87pt1ewx2p.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: disabling OIDs?  (Lonni J Friedman <netllama@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Temporary tables and disk activity
Следующее
От: "Guy Rouillier"
Дата:
Сообщение: High volume inserts - more disks or more CPUs?