Re: large classes (tables) - Mailing list pgsql-admin

From Alfred Perlstein
Subject Re: large classes (tables)
Date
Msg-id 20001109113103.V5112@fw.wintelcom.net
Whole thread Raw
In response to large classes (tables)  (Charlie Crissman <CCrissman@nbibx.com>)
List pgsql-admin
* Charlie Crissman <CCrissman@nbibx.com> [001109 04:21] wrote:
> Since we are limited to a 2G file size on unix, is that the practical limit
> to the size of a class (table) in PostgreSQL?  Is it possible for a class
> (table) to use more than one file?
>
> 2G is not a very big table in reality.

You are only limited to 2 gigabytes in Linux, I don't know of any
other modern unix with that limitation.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-admin by date:

Previous
From: "mike focosi"
Date:
Subject: Table Corruption
Next
From: "Jimi Thompson"
Date:
Subject: Implementing mod_perl, Perl 5.004, and Postgres