| From: | Boris <koester(at)x-itec(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Memory requirements for web-project |
| Date: | 2001-02-04 16:10:21 |
| Message-ID: | 1494101587.20010204171021@x-itec.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello pgsql-general,
i need to calculate the memory requirement if i am using apache+pgsql.
Lets assume that i want 160.000 hits a day and pgsql takes 3 seconds
to work for each client, how much ram is required specially for pgsql?
I think I have to calculate the memory requiremend for a specific time
period.
160.000 hits are wanted, so I calculate 160.000 div 24 = approx 6666
Hits a hour, div 60 = 111 Hits a minute, = 1,85 Hits per secound.
lets round it up to 2 hits per secound. So I calculate now
2 hits per second * 3 seconds for a client
= 6 processes at the same time,
is that correct?
If so, how much is the memory requiremend? I have seen with "TOP" that
pgsql requires 5000kb for a request, but it is used per client (new processes for
each new client-request?)
--
Boris
www.x-itec.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas T. Thai | 2001-02-04 16:31:11 | select column to text file |
| Previous Message | Ian deSouza | 2001-02-04 16:04:07 | Problem when calling setObject on Timestamp column with JDBC driver |