Re: limits? - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: limits?
Date
Msg-id 48606ECF.1020709@wildenhain.de
Whole thread Raw
In response to Re: limits?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Thomas Kellerer wrote:
> Steve Atkins wrote on 23.06.2008 20:21:
>  > In real use you're unlikely to hit any limits, theoretical or practical,
>
> I imagine that the 1GB column-value limit is something that could be
> reached though. Especially for BLOB (aka bytea) or CLOB (aka text) columns.

No, since they are stored out of band (toast tables). For *lob there is
a lob type which stored the data completely separate, not to be confused
with bytea and text (varchar).

Tino.

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tables referenced from insert...returning
Next
From: "Michael Shulman"
Date:
Subject: what are rules for?