| From: | Paulo Henrique Baptista de Oliveira <baptista(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:07:50 |
| Message-ID: | 20020715120750.421fc22d.baptista@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 | Exellon | 2002-07-15 12:22:20 | Pushing PostgreSQL to the Limit (urgent!) |
| Previous Message | Vince Vielhaber | 2002-07-15 12:01:22 | Re: OSX Install Instructions |