Pushing PostgreSQL to the Limit (urgent!)

Поиск
Список
Период
Сортировка
От Exellon
Тема Pushing PostgreSQL to the Limit (urgent!)
Дата
Msg-id 20020715122220.7839b534.exellon@linuxsolutions.com.br
обсуждение исходный текст
Список pgsql-general
    Hi all,
    I read Postgresql limits at postgresql.org:

   Maximum size for a database          unlimited (60GB databases exist)
   Maximum size for a table             64 TB on all operating systems
   Maximum size for a row               unlimited in 7.1 and later
   Maximum size for a field             1GB in 7.1 and later
   Maximum number of rows in a table    unlimited
   Maximum number of columns in a table 1600
   Maximum number of indexes on a table unlimited

    I have an app that uses a database with 60 tables and a mean of 5 fields in each table.
    I will put it to insert 30 M (millions) registers by month (or 1 Million by day) in a year is about 400 Millions
registers.
    Can pgsql support this? In What Machine?
    TIA,        Paulo Henrique.

--
Paulo Henrique B de Oliveira
Gerente de Operações - Linux Solutions - http://www.linuxsolutions.com.br
O maior conteúdo de Linux em língua portuguesa - OLinux - http://www.olinux.com.br
(21) 2526-7262 ramal 31

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

Предыдущее
От: Vitaliy Pylypiv
Дата:
Сообщение: HowTo move indices' files to other hdd ?
Следующее
От: Doug Fields
Дата:
Сообщение: Re: PostgreSQL in mission-critical system