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.