Re: Working with large text blocks

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: Clinton James <cjames(at)callone(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Working with large text blocks
Date: 2001-01-26 19:55:02
Message-ID: 20010126205502.A21348@rakete.joerdens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chean Fonk Joe Thong 2001-01-26 20:02:27 PostgreSQL 7 on Redhat 6.1
Previous Message a 2001-01-26 19:47:04 postgres limitation