Re: Regarding postgreSQL performance on DRAM

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Regarding postgreSQL performance on DRAM
Дата
Msg-id 1ee47afb-7867-adc6-0df2-c7b1f04f1576@gmx.net
обсуждение исходный текст
Ответ на Re: Regarding postgreSQL performance on DRAM  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Tom Lane schrieb am 20.02.2019 um 22:04:
>> Hmm. I though TOAST is only applied to single values, not the entire tuple (row)?
>> As each column is substantially shorter than the TOAST threshold, I would not expect toasting to kick in here.
> 
> Well, the entire tuple would be 25600 bytes plus some overhead, which
> cannot fit on a Postgres page (8K, unless the OP changed compile options
> without mentioning it).  So something has to be done to make it fit, and
> that something is going to be toasting any fields that can be toasted.

Ah, obviously.
Thanks



В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Regarding postgreSQL performance on DRAM
Следующее
От: Rohan Kadekodi
Дата:
Сообщение: Re: Regarding postgreSQL performance on DRAM