Re: Capacity planning.

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Harel <hareldvd(at)gmail(dot)com>
Cc: postgresql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Capacity planning.
Date: 2010-03-31 14:47:21
Message-ID: 201003311447.o2VElLC19795@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brad Nicholson 2010-04-01 13:12:51 Re: Capacity planning.
Previous Message Jasen Betts 2010-03-31 11:44:17 Re: Week to date function