Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group