Re: [HACKERS] Make TOAST_TUPLES_PER_PAGE configurable per table.

2010-02-02 Thread Kevin Grittner
Jesper Krogh wrote: > Ultimately I would like an infinite amount of configurabillity There was some discussion of this previously. I was thinking of doing something with it, but Laurent indicated off-list he was working on it, so I left it to him. Besides reading these threads, you might wa

Re: [HACKERS] Make TOAST_TUPLES_PER_PAGE configurable per table.

2010-02-01 Thread Jesper Krogh
Tom Lane wrote: > Jesper Krogh writes: >> This patch enables users to set TOAST_TUPLES_PER_PAGE with >> ALTER 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 unfortunate

Re: [HACKERS] Make TOAST_TUPLES_PER_PAGE configurable per table.

2010-02-01 Thread Tom Lane
Jesper Krogh writes: > This patch enables users to set TOAST_TUPLES_PER_PAGE with > ALTER 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 ha

[HACKERS] Make TOAST_TUPLES_PER_PAGE configurable per table.

2010-02-01 Thread Jesper Krogh
Hi This is my first attempt to hack PostgreSQL (even C actually), so bear over with obvious mistakes done. I've had a wish to be able to teach Postgres a bit more about how to store its data on disk. Our systems is a typical web-based system where all access more or less can be devided into 2 cat