Re: Capacity planning. - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Capacity planning.
Date
Msg-id 201003311447.o2VElLC19795@momjian.us
Whole thread Raw
In response to Capacity planning.  (David Harel <hareldvd@gmail.com>)
List 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com


pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Week to date function
Next
From: Brad Nicholson
Date:
Subject: Re: Capacity planning.