RE: large classes (tables)

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:CCrissman(at)nbibx(dot)com
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:ler(at)lerctr(dot)org]
Sent: Thursday, November 09, 2000 7:22 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] large classes (tables)

* Charlie Crissman <CCrissman(at)nbibx(dot)com> [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:CCrissman(at)nbibx(dot)com <mailto:CCrissman(at)nbibx(dot)com>
> 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: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749