Re: Max Tuple Size

Aarmel wrote:
>
> We want to insert text into a table. Large amounts of text.
>
> The limit on the version we have at the moment is around 9000 characters.
> I'd estimate we'd need to be able to insert around 20,000 to 50,000
> characters.
>
> Does Version 7.0.3 have a limit, is 7.1 the only version with no limit.
>
> Are there confiuration settings in postgres to set a limit? or do I just
> have to use blobs and lobs :(

In 7.0.3 you can use LZTEXT which gives good compression for most
strings, managing to fit 50k in with that should be no problem if it is
english (or other) language text. I've successfully stuffed over 200k
into an LZTEXT field if it is especially compressible.

You can also increase the blocksize to 32k if you compile from source
and re-initialise your database. Combining this with LZTEXT gives a
corresponding increase.

In 7.1 the limit is increased through arcane magic to (I think) around
2GB, possibly more, if you can make assumptions like "it won't be
indexed". Even in 7.0.3 you can only index fields up to blocksize/3.

Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)catalyst(dot)net(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267