Database ressources utilisation

From: "Prescott, Richard (EXP)" <richard(dot)prescott(at)lmco(dot)com>
To: "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org>
Subject: Database ressources utilisation
Date: 2000-10-10 22:21:50
Message-ID: 0DC5E833533ED4119B1500508BDF57DC1C8892@emss52m02.lmcda.lmco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I am in the design process of a system where I trying to incorporate
PostgreSQL as the framework.

I am trying to figuring out:
- how much memory I need and
- how much disk space I need.

for a given:
- schema (number of tables, views, triggers, contraints...),
- number of rows in all tables
- number of client connecting to the database and their requests
- time spent in triggers
- periods of client requests
- network speeds and overhead
- OS memory / disk space overhead

Does anyone know/guess any formula?

Thanks.

Richard

NOTE: CPU time and network usage can be derived from that.
NOTE2: I know the "explain" command but I don't know how it reach its
result.
NOTE3: I am novice in database system but a bit more familiar in real time
system

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-10-10 22:43:30 Re: Re: [HACKERS] My new job
Previous Message Tom Lane 2000-10-10 22:10:25 Re: Re: [HACKERS] My new job