Re: Fwd: [GENERAL] 4B row limit for CLOB tables

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Дата
Msg-id 54D16A63.7000902@pgmasters.net
обсуждение исходный текст
Ответ на Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
On 2/3/15 5:27 PM, Jim Nasby wrote:
> On 2/3/15 9:50 AM, David Steele wrote:
>> EXTENDED is the default for most TOAST-able types and is still subject
>> to TOAST_TUPLE_THRESHOLD which is normally 2K. EXTERNAL is the same but
>> with no compression.
>>
>> See: http://www.postgresql.org/docs/9.4/static/storage-toast.html
>
> Right. I'd like to be able to set per-column TOAST_TUPLE_THRESHOLD.

No argument there.  There are some columns that I would prefer to always
TOAST because even 2K can be very big for some use cases.

--
- David Steele
david@pgmasters.net



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

Предыдущее
От: Noah Yetter
Дата:
Сообщение: GRANT USAGE on FOREIGN SERVER exposes passwords
Следующее
От: BladeOfLight16
Дата:
Сообщение: Re: [GENERAL] How do I bump a row to the front of sort efficiently