The row size limit - HELP

Поиск
Список
Период
Сортировка
От Esa Pikkarainen
Тема The row size limit - HELP
Дата
Msg-id 4AD8E090F3A@ktk.oulu.fi
обсуждение исходный текст
Ответы Re: The row size limit - HELP
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Justin
Дата:
Сообщение: Re: How do I create a check constraint that is based on age difference?
Следующее
От:
Дата:
Сообщение: Re: select distinct null