Jan Wieck wrote:
> Poul L. Christiansen wrote:
> > 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.
> TOAST is finished and will be shipped with 7.1. It's not a
> solution for huge items, but medium sized text up to some
> hundred K works fine.
What do you mean by "..not a solution for huge items"? Does TOAST have a size limit?
> > 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.
> # It's easier to get forgiveness for being wrong than for being right. #
> # Let's break this rule - forgive me. #
> #================================================== JanWieck(at)Yahoo(dot)com #
In response to
pgsql-sql by date
|Next:||From: Ingram, Bryan||Date: 2000-08-21 15:37:13|
|Subject: Best way to create DML/DDL log?|
|Previous:||From: Keith Wong||Date: 2000-08-21 14:48:27|
|Subject: Copying data with triggers|