Re: 8K Limit, whats the best strategy?

Poul L. Christiansen <plc@faroenet.fo>

From: "Poul L. Christiansen" <plc@faroenet.fo>
To: Keith Wong <keith@e-magine.com.au>
Cc: pgsql-sql@postgresql.org
Date: 2000-08-15T17:49:43Z
Lists: pgsql-sql
I've just split the text up (in 8 pieces), so it fits into 8K rows. But thats
only a viable solution if your text is less than a couple of 100K's.

You could try to be a daredevil and use the Toast code, even if it's beta. But
I don't know how far the Toast project has come.

Keith Wong wrote:

> Hi everyone,
>
> Just wondering what strategies people have used to get around the 8K row
> limit in Postgres.
> If anyone has been troubled by this limitation before and has a nice
> solution around it, I would love to hear it.
>
> My application is a web-based system in which needs to store large amounts
> of text.
> The text stored needs to searchable as well.
>
> Cheers,
> Keith.