Re: information - Mailing list pgsql-novice

From Tom Lane
Subject Re: information
Date
Msg-id 13408.1034905156@sss.pgh.pa.us
Whole thread Raw
In response to Re: information  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: information
List pgsql-novice
"Josh Berkus" <josh@agliodbs.com> writes:
> FYI, most operating systems limit single files to 2GB or less.  As
> such, no table -- and thus no row -- in a Postgres database running on
> that operating system can be larger than 2GB.

Josh, surely you know better than that.  PG is not restricted by OS
limitations on individual file size, because it automatically segments
tables into multiple OS files.

            regards, tom lane

pgsql-novice by date:

Previous
From: Randy Neumann
Date:
Subject: Re: char() or varchar() for frequently used column
Next
From: "Josh Berkus"
Date:
Subject: Re: information