Sizing of LARGE databases.

From: "Michael Miyabara-McCaskey" <mykarz(at)miyabara(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Sizing of LARGE databases.
Date: 2001-01-31 04:17:22
Message-ID: 000c01c08b3c$b5d72b90$c700a8c0@ncc1701e
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hello there,

I have a DB that I am attempting to buy "the right hardware" for.

This DB today is about 25GB total, with typical tables in the area of 3GB in
size, and up to about 20 million records per table for the big tables.

Is there any set of recommendations for sizing a DB using PostgreSQL? (I
have all the docs but have not found anything of any use).

This DB itself will be mostly reads, for a decision system. However, there
will be a lot more data added in the future where the DB could easily grow
to about 150GB in size, and up to about 60millions records for the large
tables.

My current setup is Linux RH7 w/PostgreSQL 7.0.2, my intention is to build a
large array of Linux Clusters, but I also can not find any documentation on
how if at all PostgreSQL handles a clustered environment. (Although I did
see something that said you could have multiple "databases" and use a create
view to stich together multiple tables from different DBs in a HOWTO on the
www.kernel.org/LDP I have also noticed that the doc is longer there, and
people who have posted about how to do this on these forums have been told
this method does not work).

Any thoughts would be greatly appreciated.

Michael Miyabara-McCaskey
Email: mykarz(at)miyabara(dot)com
Web: http://www.miyabara.com/mykarz/
Mobile: +1 408 504 9014

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-01-31 05:30:37 Re: Sizing of LARGE databases.
Previous Message Michael Miyabara-McCaskey 2001-01-31 04:16:39 Queries against multi-million record tables.

Browse pgsql-novice by date

  From Date Subject
Next Message Justin Clift 2001-01-31 05:30:37 Re: Sizing of LARGE databases.
Previous Message Michael Miyabara-McCaskey 2001-01-31 04:16:39 Queries against multi-million record tables.