Thread: Working with large text blocks

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?  I'll have Win NT as a client
getting the data from a Linux box through ODBC so BLOBs don't appear a good
idea, or maybe I just don't understand.  Can anyone point me in the right
direction?

Clinton James

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

The field data type is TEXT.  I don't think you need to do anything special
(as long as you are using 7.1).

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Clinton James" <cjames@callone.net>
To: <pgsql-general@postgresql.org>
Sent: Friday, January 26, 2001 2:45 PM
Subject: [GENERAL] Working with large text blocks


> 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?  I'll have Win NT as a client
> getting the data from a Linux box through ODBC so BLOBs don't appear a
good
> idea, or maybe I just don't understand.  Can anyone point me in the right
> direction?
>
> Clinton James