The row size limit - HELP

From: "Esa Pikkarainen" <epikkara(at)ktk(dot)oulu(dot)fi>
To: pgsql-general(at)postgresql(dot)org
Subject: The row size limit - HELP
Date: 2001-01-05 07:41:39
Message-ID: 4AD8E090F3A@ktk.oulu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
(Sorry if this topic is already discussed too many times...)

I am porting a discussion forum database from Access to Postgresql.
(see: http://wwwedu.oulu.fi/dialogue)
Now I am facing the problem of only 8K row limit.
The main table contains the messages and it has some 16 columns. Most
of them are short but the proper message body column is quite large.
I just checked and the average length is 9K and longest are about 25-
26K.

Now (according to faq) there seems to be four possibilities open:

1) wait for version 7.1. How long that will take???

2) configure row limit to 32K. Is this a complicated process?? Side
effects?? After all even then size could be not enough!!

3) use "large object interface": This is most interesting! But what
it means??? where I can find more practical information about this???

4) save message bodies as files. There are 1655 rows now, so I am not
very interested in this possibility...

Thank you, I am very happy if you can give me some hints and
especially advice in the 3th alternative.
Esa Pikkarainen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2001-01-05 08:58:25 Re: The row size limit - HELP
Previous Message Justin 2001-01-05 07:14:24 Re: How do I create a check constraint that is based on age difference?