Thanks for that info... any documentation on how it does that? Is there
something tunable to this? Lets say our table is called 'tablename', will
it just start a new file called 'tablename_2', or something like that? Is
there something that tells it that it is reaching the 2G limit, or does it
just start a new one when it fails?
Thanks, Charlie Crissman
Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684
mailto:[EMAIL PROTECTED]
Before you criticize someone, you should walk a mile in their shoes.
That way, when you criticize them, you're a mile away and you have their
shoes.
-----Original Message-----
From: Larry Rosenman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 7:22 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] large classes (tables)
* Charlie Crissman <[EMAIL PROTECTED]> [001109 06:16]:
> 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.
No, PostgreSQL will split the tables up and use multiple filesystem
files.
>
> Charlie
>
>
> Charlie Crissman
> Sr. Oracle DBA
> Oracle Certified Professional DBA
> No Boundaries Network, Inc.
> 904-245-6839
> Pager 904-840-3684
> mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Before you criticize someone, you should walk a mile in their shoes.
> That way, when you criticize them, you're a mile away and you have their
> shoes.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
