Quoting Joe Conway <joseph(dot)conway(at)home(dot)com>:
> TEXT is a datatype which stores character data of unspecified length (up
> the max value of a 4 byte integer in length, although I've seen
> 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 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
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2001-08-24 14:42:48|
|Subject: Re: User locks code|
|Previous:||From: Peter Eisentraut||Date: 2001-08-24 14:24:27|
|Subject: Re: A couple items on TODO |