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: | Raw Message | Whole Thread | 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 |