Re: Working with large text blocks - Mailing list pgsql-general

From Frank Joerdens
Subject Re: Working with large text blocks
Date
Msg-id 20010126205502.A21348@rakete.joerdens.de
Whole thread Raw
In response to Working with large text blocks  ("Clinton James" <cjames@callone.net>)
List pgsql-general
On Fri, Jan 26, 2001 at 01:45:33PM -0600, Clinton James wrote:
> I have some blocks of text than can be from 2K to 80K in size. I understand
> 7.1 will have compression to use with text, but does anyone know of a way I
> can use these large text blocks as a field?

The unlimited row width feature in 7.1, aka TOAST (the best thing since
sliced bread), works transparently, so in actual fact, you can have your
text in a text field. You won't notice anything of the compression, if
TOAST decides it is needed.

Regards, Frank

pgsql-general by date:

Previous
From: "Clinton James"
Date:
Subject: Working with large text blocks
Next
From: Chean Fonk Joe Thong
Date:
Subject: PostgreSQL 7 on Redhat 6.1