pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Antti Linno <alligator@all.ee>
To: pgsql-sql@postgresql.org
Subject: Re: TEXT field size
Date: Tue, 26 Jun 2001 14:34:58 +0100
Message-ID: <007701c0fe44$cbe09c20$1001a8c0@archonet.com> (raw)
References: <Pine.LNX.4.04.10106261331110.29082-100000@all.ee>

From: "Antti Linno" <alligator@all.ee>

> Hallo.
>
> Maybe its not the right list, but does the Postgres 7.1 support now
> unlimited text field? In previous versions it was limited to max 31k, or
> even less, depending on the compilation etc.

Yes - look for details of TOAST in the docs. Text fields can be effectively
unlimited and IIRC might even get compressed if circumstances look good.
There were some issues with old clients (ODBC/JDBC etc) not knowing this and
enforcing the old 8KB rule but I think they're probably updated now.

- Richard Huxton




view thread (2+ messages)

Message-ID: <007701c0fe44$cbe09c20$1001a8c0@archonet.com>
Permalink:  ../007701c0fe44$cbe09c20$1001a8c0@archonet.com/
Also on:    postgresql.org/message-id/007701c0fe44$cbe09c20$1001a8c0@archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dev@archonet.com, alligator@all.ee
  Subject: Re: TEXT field size
  In-Reply-To: <007701c0fe44$cbe09c20$1001a8c0@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox