large classes (tables)

Поиск
Список
Период
Сортировка
Искать

large classes (tables)

От:
Charlie Crissman <CCrissman@nbibx.com>
Дата:
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.

Charlie


Charlie Crissman
Sr. Oracle DBA
Oracle Certified Professional DBA
No Boundaries Network, Inc.
904-245-6839
Pager 904-840-3684
mailto:CCrissman@nbibx.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.

Re: large classes (tables)

От:
Larry Rosenman <ler@lerctr.org>
Дата:
* Charlie Crissman  [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@nbibx.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

RE: large classes (tables)

От:
Charlie Crissman <CCrissman@nbibx.com>
Дата:
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@nbibx.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@lerctr.org] 
Sent:	Thursday, November 09, 2000 7:22 AM
To:	pgsql-admin@postgresql.org
Subject:	Re: [ADMIN] large classes (tables)

* Charlie Crissman  [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@nbibx.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: large classes (tables)

От:
Larry Rosenman <ler@lerctr.org>
Дата:
* Charlie Crissman  [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@nbibx.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@lerctr.org] 
> Sent:	Thursday, November 09, 2000 7:22 AM
> To:	pgsql-admin@postgresql.org
> Subject:	Re: [ADMIN] large classes (tables)
> 
> * Charlie Crissman  [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@nbibx.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@lerctr.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: large classes (tables)

От:
Brook Milligan <brook@biology.nmsu.edu>
Дата:
   Since we are limited to a 2G file size on unix, is that the practical limit

To be precise, only some Unix-like OSes are limited to 2G file sizes.
NetBSD has had 64-bit filesystems (hence, the limit is much larger
than 2G) for _many_ years (probably at least 6) already.

Cheers,
Brook

Re: large classes (tables)

От:
Alfred Perlstein <bright@wintelcom.net>
Дата:
* Charlie Crissman  [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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."
FAQ