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

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 (view raw or flat)
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

pgsql-admin by date

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

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