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

RE: large classes (tables)

From: Charlie Crissman <CCrissman(at)nbibx(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: RE: large classes (tables)
Date: 2000-11-09 12:32:25
Message-ID: 7309940DCB64D411A91B00508BD94F5708245B@nbimail1.jax.nbibx.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Larry RosenmanDate: 2000-11-09 12:33:13
Subject: Re: large classes (tables)
Previous:From: Larry RosenmanDate: 2000-11-09 12:21:50
Subject: Re: large classes (tables)

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