Re: Any risk in increasing BLCKSZ to get larger tuples?

Philip Hallstrom <philip(at)adhesivemedia(dot)com> writes:
> larger than the builtin limit for tuples. Is there anything I should be
> aware of before changing the below value and recompiling?

Only that it will force an initdb. Note the 32k limit, too.

A trick you can use in 7.0.* to squeeze out a little more space is
to declare your large text fields as "lztext" --- this invokes
inline compression, which might get you a factor of 2 or so on typical
mail messages. lztext will go away again in 7.1, since TOAST supersedes
it, but for now it's a useful thing to know about.

> Also, it looks like the TOAST stuff would solve this (right/wrong?), but
> it's not going to be ready for 7.1 (right/wrong?)

Right, and wrong. It's been done for months...

regards, tom lane