Received: from tangent.ics.olemiss.edu (IDENT:root@tangent.ics.olemiss.edu [130.74.31.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FFdYn14540 for ; Tue, 15 Aug 2000 11:39:34 -0400 (EDT) Received: from Betelgeuse.olemiss.edu (wsp000771wss.ics.olemiss.edu [130.74.31.251]) by tangent.ics.olemiss.edu (8.9.3/8.8.7) with ESMTP id KAA17522; Tue, 15 Aug 2000 10:37:52 -0500 Message-Id: <5.0.0.11.2.20000815103331.01f24460@sunset.backbone.olemiss.edu> X-Sender: tswan@sunset.backbone.olemiss.edu X-Mailer: QUALCOMM Windows Eudora Version 5.0.0.11 (Beta) Date: Tue, 15 Aug 2000 10:37:50 -0500 To: Keith Wong , pgsql-sql@postgresql.org From: Thomas Swan Subject: Re: 8K Limit, whats the best strategy? In-Reply-To: <4.3.2.7.0.20000815212429.00b0eda0@mail.e-magine.com.au> References: <3999029A.1E39AAAB@abas.de> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_30944234==_.ALT" X-Archive-Number: 200008/111 --=====================_30944234==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed 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." --=====================_30944234==_.ALT Content-Type: text/html; charset="us-ascii" 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." --=====================_30944234==_.ALT--