Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 23:50:46
Message-ID:
4A31520602000025000279AE@gw.wicourts.gov (view raw or flat )
Thread:
2009-06-11 14:32:51 from Shadar <shauldar(at)gmail(dot)com>
2009-06-11 14:54:23 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-06-11 14:58:15 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-11 15:05:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-11 15:24:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-11 15:41:22 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-06-11 15:44:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-11 15:52:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-11 16:12:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-11 20:19:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-11 21:20:55 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-06-11 22:03:24 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-11 22:13:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-11 23:50:46 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-12 10:54:40 from Shadar <shauldar(at)gmail(dot)com>
2009-06-12 14:33:33 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-12 14:45:24 from Shadar <shauldar(at)gmail(dot)com>
2009-06-12 15:24:26 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-06-15 17:02:27 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-07-22 01:23:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-11 15:03:49 from Shadar <shauldar(at)gmail(dot)com>
2009-06-11 15:08:44 from Greg Stark <stark(at)enterprisedb(dot)com>
Lists:
pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>> So it would be premature to submit a patch for changing this
behavior?
>
> No, I don't think so, since there's no apparent need for a control
knob.
> You just change the limit that's applied during the last phase of
> toast_insert_or_update.
Proposed patch attached.
-Kevin
In response to
Responses
pgsql-hackers by date
Next :From: suylivarDate: 2009-06-12 03:10:03
Subject : PostgreSQL installation
Previous :From : Bruce MomjianDate : 2009-06-11 23:39:47
Subject : Re: AlterTableCreateToastTable API still not right for
pg_migrator