Re: [SQL] Capacity planning.

2010-04-01 Thread Brad Nicholson
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 ques

Re: [SQL] Capacity planning.

2010-03-31 Thread Bruce Momjian
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 shou

[SQL] Capacity planning.

2010-03-25 Thread David Harel
Hi, Any way to get transaction count from the postgres daemon or any log? 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. -- Regards. David Harel, == Home office +972 77 76