Skip site navigation (1) Skip section navigation (2)

Re: Toast, Text, blob bytea Huh?

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Joe Conway <joseph(dot)conway(at)home(dot)com>
Cc: jason(dot)ory(at)ndchealth(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Toast, Text, blob bytea Huh?
Date: 2001-08-24 14:27:48
Message-ID: 998663268.3b8664649b304@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-hackers
Quoting Joe Conway <joseph(dot)conway(at)home(dot)com>:

> TEXT is a datatype which stores character data of unspecified length (up
> to
> the max value of a 4 byte integer in length, although I've seen
> comments
> indicating that the practical limit is closer to 1 GB -- not sure why).

It may be something to do with the 1Gb splitting of the physical files 
representing a table... Unless it changed recently, a table was split over 
multiple files at the 1Gb mark.

Peter

-- 
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-08-24 14:42:48
Subject: Re: User locks code
Previous:From: Peter EisentrautDate: 2001-08-24 14:24:27
Subject: Re: A couple items on TODO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group