Re: large text fields?

Поиск
Список
Период
Сортировка
От Ron Peterson
Тема Re: large text fields?
Дата
Msg-id 39478FD0.FA133344@yellowbank.com
обсуждение исходный текст
Ответ на large text fields?  (Mike Salib <msalib@MIT.EDU>)
Ответы Re: large text fields?
Список pgsql-general
Mike Salib wrote:
>
> Hi,
> I'm trying to find out if I can store more than 8k characters of data in
> one field in a single row. I'm working on a web based app and limiting
> myself to 8k posts is problematic. Has this limitation changed in
> Postgres 7?

No.  You have three options, I think.

(1) Increase the data page size and recompile.

(2) Use the large object interface.

(3) Check out Jan Wieck's TOAST project
(http://www.postgresql.org/projects/devel-toast.html).  It's still in
development, but maybe you can help.

________________________
Ron Peterson
rpeterson@yellowbank.com

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

Предыдущее
От: Ron Peterson
Дата:
Сообщение: Re: Postgresql and programming
Следующее
От: "Mirko Geffken"
Дата:
Сообщение: Performance of PostgreSQL vs. Other DBs