From: | "Poul L(dot) Christiansen" <plc(at)faroenet(dot)fo> |
---|---|
To: | Jan Wieck <janwieck(at)Yahoo(dot)com> |
Cc: | Keith Wong <keith(at)e-magine(dot)com(dot)au>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: 8K Limit, whats the best strategy? |
Date: | 2000-08-21 15:20:24 |
Message-ID: | 39A148B7.7D67B0BD@faroenet.fo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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?
>
>
> Jan
>
> >
> > 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 #
From | Date | Subject | |
---|---|---|---|
Next Message | Ingram, Bryan | 2000-08-21 15:37:13 | Best way to create DML/DDL log? |
Previous Message | Keith Wong | 2000-08-21 14:48:27 | Copying data with triggers |