Pushing PostgreSQL to the Limit (urgent!)

Поиск
Список
Период
Сортировка
От Paulo Henrique Baptista de Oliveira
Тема Pushing PostgreSQL to the Limit (urgent!)
Дата
Msg-id 20020715120750.421fc22d.baptista@linuxsolutions.com.br
обсуждение исходный текст
Ответы memory  ("David Blood" <david@matraex.com>)
Re: Pushing PostgreSQL to the Limit (urgent!)  (Chris Albertson <chrisalbertson90278@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Joe Block
Дата:
Сообщение: Re: OSX Install Instructions
Следующее
От: Nikolay Hristov
Дата:
Сообщение: Embedded SQL in a function