From: | Exellon <exellon(at)linuxsolutions(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Pushing PostgreSQL to the Limit (urgent!) |
Date: | 2002-07-15 12:22:20 |
Message-ID: | 20020715122220.7839b534.exellon@linuxsolutions.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-07-15 12:47:32 | Re: 7.2.1 optimises very badly against 7.2 |
Previous Message | Paulo Henrique Baptista de Oliveira | 2002-07-15 12:07:50 | Pushing PostgreSQL to the Limit (urgent!) |