Received: from faroenet.fo ([212.55.59.140]) by hub.org (8.10.1/8.10.1) with SMTP id e7LFKDT80543 for ; Mon, 21 Aug 2000 11:20:14 -0400 (EDT) Received: (qmail 23433 invoked by uid 7719); 21 Aug 2000 16:25:14 -0000 Received: from unknown (HELO faroenet.fo) (192.168.1.21) by 192.168.1.1 with SMTP; 21 Aug 2000 16:25:14 -0000 Message-ID: <39A148B7.7D67B0BD@faroenet.fo> Date: Mon, 21 Aug 2000 16:20:24 +0100 From: "Poul L. Christiansen" Reply-To: pgsql-sql@postgresql.org X-Mailer: Mozilla 4.71 [en] (WinNT; U) X-Accept-Language: en,pdf MIME-Version: 1.0 To: Jan Wieck CC: Keith Wong , pgsql-sql@postgresql.org Subject: Re: 8K Limit, whats the best strategy? References: <200008211541.KAA02852@jupiter.greatbridge.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/202 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@Yahoo.com #