Thread: Capacity planning.

Capacity planning.

From
David Harel
Date:
<p style="margin-bottom: 0cm; margin-top: 0pt;"><font size="+1"><font face="Arial">Hi,</font></font><p
style="margin-bottom:0cm; margin-top: 0pt;"><br /><p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size:18px;"><font face="Arial">Any way to get transaction count from the postgres daemon or any log?<br
/></font></span><spanstyle="font-size: 18px;"></span><p style="margin-bottom: 0cm; margin-top: 0pt;"><span
style="font-size:18px;"><font face="Arial">Also where can I find docs that can help me make a capacity plan for max
100,000clients making around 200 transactions a day each.<br /></font></span><span style="font-size: 18px;"></span><p
style="margin-bottom:0cm; margin-top: 0pt;"><br /><pre class="moz-signature" cols="72">-- 
 
Regards.

David Harel,

==================================

Home office +972 77 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka           D.N Merom Hagalil           13802           Israel
Email:      <a class="moz-txt-link-abbreviated" href="mailto:hareldvd@ergolight-sw.com">hareldvd@ergolight-sw.com</a>

</pre>

Re: Capacity planning.

From
Bruce Momjian
Date:
David Harel wrote:
> Hi,
> 
> 
> Any way to get transaction count from the postgres daemon or any log?

See the system view pg_stat_database.

> Also where can I find docs that can help me make a capacity plan for max 
> 100,000 clients making around 200 transactions a day each.

No idea.  You should be using connection pooling for that setup.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com


Re: Capacity planning.

From
Brad Nicholson
Date:
On Thu, 2010-03-25 at 16:02 +0200, David Harel wrote:

> Also where can I find docs that can help me make a capacity plan for
> max 100,000 clients making around 200 transactions a day each.

You will need a whole lot more information than that in order to do
capacity planning.

Here are a few questions to get you started

-What is the expected percentage of read vs write transactions.  
-Are they small OLTP style writes, or larger ones?
-Do you expect these transactions to be equally distributed over the
day, or do you expect bursts?
-Are you going to be dealing with highly concurrent access, or is it
distributed?
-what is the expected cache hit ratio?
-what is the expected data size?  What is the expected growth rate?

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.