Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8505F633A9B for ; Wed, 31 Mar 2010 11:47:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59486-01-10 for ; Wed, 31 Mar 2010 14:47:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 07987633E38 for ; Wed, 31 Mar 2010 11:47:22 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id o2VElLC19795; Wed, 31 Mar 2010 10:47:21 -0400 (EDT) From: Bruce Momjian Message-Id: <201003311447.o2VElLC19795@momjian.us> Subject: Re: Capacity planning. In-Reply-To: <4BAB6D03.7010905@gmail.com> To: David Harel Date: Wed, 31 Mar 2010 10:47:21 -0400 (EDT) CC: postgresql X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/220 X-Sequence-Number: 33927 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 http://momjian.us EnterpriseDB http://enterprisedb.com