Thread: Capacity planning.
<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>
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
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.