Skip site navigation (1) Skip section navigation (2)

set variable for TOAST_TUPLE_THRESHOLD

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: pgsql-hackers(at)postgresql(dot)org
Subject: set variable for TOAST_TUPLE_THRESHOLD
Date: 2004-11-29 15:43:35
Message-ID: 1101743015.3999.4.camel@fuji.krosing.net (view raw or flat)
Thread:
Lists: 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 by date

Next:From: Andreas PflugDate: 2004-11-29 16:03:38
Subject: Re: Error: column "nsptablespace" does not exist
Previous:From: Tom LaneDate: 2004-11-29 15:42:29
Subject: Re: multiline CSV fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group