Skip site navigation (1) Skip section navigation (2)

Re: 8K Limit, whats the best strategy?

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 (view raw or flat)
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 #


In response to

Responses

pgsql-sql by date

Next:From: Ingram, BryanDate: 2000-08-21 15:37:13
Subject: Best way to create DML/DDL log?
Previous:From: Keith WongDate: 2000-08-21 14:48:27
Subject: Copying data with triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group