Re: Make TOAST_TUPLES_PER_PAGE configurable per table.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Make TOAST_TUPLES_PER_PAGE configurable per table.
Дата
Msg-id 19554.1265069352@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Make TOAST_TUPLES_PER_PAGE configurable per table.  (Jesper Krogh <jesper@krogh.cc>)
Ответы Re: Make TOAST_TUPLES_PER_PAGE configurable per table.  (Jesper Krogh <jesper@krogh.cc>)
Список pgsql-hackers
Jesper Krogh <jesper@krogh.cc> writes:
> This patch enables users to set TOAST_TUPLES_PER_PAGE with
> ALTER TABLE <table> SET (tuples_per_page = X); .. currently with 1 <= X
> <= 32;

It's not clear to me that fiddling with that is useful unless the toast
tuple size also changes; and unfortunately changing that is much harder,
because it's wired into the addressing of toast data.  See also these
notes:
* XXX while these can be modified without initdb, some thought needs to be* given to needs_toast_table() in toasting.c
beforeunleashing random* changes.  Also see LOBLKSIZE in large_object.h, which can *not* be* changed without initdb.
 
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Database-Role settings behaviour and docs mismatch
Следующее
От: Takahiro Itagaki
Дата:
Сообщение: Re: Largeobject Access Controls (r2460)