Thread: large classes (tables)
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 <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.
* Charlie Crissman <CCrissman@nbibx.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@nbibx.com <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
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 <CCrissman@nbibx.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@nbibx.com <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
* Charlie Crissman <CCrissman@nbibx.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@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 <CCrissman@nbibx.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@nbibx.com <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
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
* Charlie Crissman <CCrissman@nbibx.com> [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."