set variable for TOAST_TUPLE_THRESHOLD

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема set variable for TOAST_TUPLE_THRESHOLD
Дата
Msg-id 1101743015.3999.4.camel@fuji.krosing.net
обсуждение исходный текст
Список pgsql-hackers
Hi

I would like to test, how storing one biggish (~450 bytes bytea) column
into toast table would affect my applications performance.

is there a way to set the values used for this using some SET variable
or some column in system tables.

or is my only option to build a custom version of server with changed 
TOAST_TUPLE_THRESHOLD/TOAST_TUPLE_TARGET (in
src/include/access/tuptoaster.h) as advised by Tom Lane in
http://listcrawler.com/message2.jsp?id=53577

--------------
Hannu



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