Re: large classes (tables)

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: large classes (tables)
Дата
Msg-id 20001109062150.A20362@lerami.lerctr.org
обсуждение исходный текст
Ответ на large classes (tables)  (Charlie Crissman <CCrissman@nbibx.com>)
Список pgsql-admin
* 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Charlie Crissman
Дата:
Сообщение: large classes (tables)
Следующее
От: Charlie Crissman
Дата:
Сообщение: RE: large classes (tables)