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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: multiline CSV fields
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: Error: column "nsptablespace" does not exist