Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FFlDn18195 for ; Tue, 15 Aug 2000 11:47:15 -0400 (EDT) Received: from Adam ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id LAA02922 for ; Tue, 15 Aug 2000 11:50:41 -0400 Message-ID: <00a801c006d0$36eadde0$330a0a0a@Adam> From: "Adam Lang" To: References: <3999029A.1E39AAAB@abas.de> <5.0.0.11.2.20000815103331.01f24460@sunset.backbone.olemiss.edu> Subject: Re: 8K Limit, whats the best strategy? Date: Tue, 15 Aug 2000 11:48:10 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/112 I believe you are correct. Version 7.1 will supposedly eliminate the row size. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Thomas Swan" To: "Keith Wong" ; Sent: Tuesday, August 15, 2000 11:37 AM Subject: Re: [SQL] 8K Limit, whats the best strategy? > At 06:29 AM 8/15/2000, 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. > > You can you the type LZTEXT which is compressed text so your mileage will vary. > > The other option is to go in and recompile for a larger row size. Most of > the people I have talked to had no problems with this route. I move the > size limit on an x86 Linux box to 32K (the max) and have not had any > problems. In the next release, I don't believe the row size limit will > exist (correct me if I'm wrong). > > Let me know the system your on, and I will try to help if I can. > > - > - Thomas Swan > - Graduate Student - Computer Science > - The University of Mississippi > - > - "People can be categorized into two fundamental > - groups, those that divide people into two groups > - and those that don't."