Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: "Greg Stark" <stark(at)enterprisedb(dot)com>, "Shadar" <shauldar(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Date: 2009-06-11 15:52:13
Message-ID: 24379.1244735533@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Greg Stark <stark(at)enterprisedb(dot)com> wrote:
>> tuptoaster.c only has one definition of "small enough" which is
>> whether the record is smaller than TOAST_TUPLE_THRESHOLD.

> So what *is* the difference between EXTENDED and MAIN?

EXTENDED columns get pushed out first. So if you have some EXTENDED
columns and some MAIN columns, it'll give preference to keeping the
MAIN columns in-line. In the OP's case there's only one wide column
so this is of no help.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-06-11 16:12:22 Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Previous Message David E. Wheeler 2009-06-11 15:49:56 Re: [PATCH][v8.5] SE-PostgreSQL Patch Updates (r2016)