Re: large classes (tables)

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Charlie Crissman <CCrissman(at)nbibx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: large classes (tables)
Date: 2000-11-09 19:31:03
Message-ID: 20001109113103.V5112@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

* Charlie Crissman <CCrissman(at)nbibx(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jimi Thompson 2000-11-09 21:25:54 Implementing mod_perl, Perl 5.004, and Postgres
Previous Message Tom Lane 2000-11-09 17:19:47 Re: Table Corruption