Re: [GENERAL] I need your help to get opinions about this situation

2011-03-04 Thread Rayner Julio Rodríguez Pimentel
Thanks to David and Greg, your responses helped me so much to organize my ideas. I'm agree with your opinions. The problem is that I have to build a solid data architecture for a comercial system that will have many reading queries and in some peak times many clients executing their. Thanks again.

Re: [GENERAL] I need your help to get opinions about this situation

2011-03-03 Thread Greg Williamson
Rayner -- <...> > I have a database of 1000 tables, 300 of theirs are of major growing > with 1 rows daily, the estimate growing for this database is of > 2,6 TB every year. In and of-itself sheer number of rows only hits you when you need to be reading most of them; in that case good hardw

Re: [GENERAL] I need your help to get opinions about this situation

2011-03-03 Thread David Johnston
fford. David J. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rayner Julio Rodríguez Pimentel Sent: Wednesday, March 02, 2011 10:41 AM To: pgsql-general@postgresql.org Subject: [GENERAL] I need your help to get opinions about

[GENERAL] I need your help to get opinions about this situation

2011-03-02 Thread Rayner Julio Rodríguez Pimentel
Hello to everybody, I have this situation that I would to know your opinions about it, to confirm some elements that secure me of use the amazing database system PostgreSQL. I have a database of 1000 tables, 300 of theirs are of major growing with 1 rows daily, the estimate growing for this dat