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
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 |