Re: large classes (tables)

* Charlie Crissman <CCrissman(at)nbibx(dot)com> [001109 06:29]:
> 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?
>
I believe previous discussions go into details. I believe it splits
at the 1G mark, but one of the -hackers guys will have to answer for
sure.

LER

> 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
--
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