Re: Make TOAST_TUPLES_PER_PAGE configurable per table. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Make TOAST_TUPLES_PER_PAGE configurable per table.
Date
Msg-id 19554.1265069352@sss.pgh.pa.us
Whole thread Raw
In response to Make TOAST_TUPLES_PER_PAGE configurable per table.  (Jesper Krogh <jesper@krogh.cc>)
Responses Re: Make TOAST_TUPLES_PER_PAGE configurable per table.
List pgsql-hackers
Jesper Krogh <jesper@krogh.cc> writes:
> This patch enables users to set TOAST_TUPLES_PER_PAGE with
> ALTER TABLE <table> SET (tuples_per_page = X); .. currently with 1 <= X
> <= 32;

It's not clear to me that fiddling with that is useful unless the toast
tuple size also changes; and unfortunately changing that is much harder,
because it's wired into the addressing of toast data.  See also these
notes:
* XXX while these can be modified without initdb, some thought needs to be* given to needs_toast_table() in toasting.c
beforeunleashing random* changes.  Also see LOBLKSIZE in large_object.h, which can *not* be* changed without initdb.
 
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database-Role settings behaviour and docs mismatch
Next
From: Takahiro Itagaki
Date:
Subject: Re: Largeobject Access Controls (r2460)