From hareldvd@gmail.com Thu Mar  25 14:02:59 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 28835632BF4
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 11:02:59 -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 11073-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 14:02:47 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f224.google.com (mail-fx0-f224.google.com
	[209.85.220.224])
	by mail.postgresql.org (Postfix) with ESMTP id 75DE9632817
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 11:02:47 -0300 (ADT)
Received: by fxm24 with SMTP id 24so3127749fxm.3
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 07:02:45 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:content-type;
	bh=Dli+zfjKYd/kc2Yt6MSAxVeZ0jHQX/hX3D/NWvjSo64=;
	b=sOYSHnnCvXbJ2xtGC3CpqGyWJHaMhZw5B95A2PMRaitaFe5RmHVgsrvcztv5ZQzQFB
	yPeP9wtYYRT3qct8WKpLYWRxlchLH++aSDvIfPx907VYlElr5ZyYElsROAhlXBUNOAGV
	gaFQdTDrmmHDvFhKPY0A7bhaSvTMvnAZEvjik=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type;
	b=mdpUOuQDXVLciD+OuxITefVW0xehEcV4GdwTlZ8ZJM15ovp1bOysnVACCckcKnLX1o
	rT4/cCbH7pmLoizdyo+kkk2Lt/ER/oEnZ42Vr5m4GcjX2WrGkSZYgc+lwtiOrHmYbqds
	HhK3MJGe/6u6+0yIrMSihdwB96eXPBnN4pems=
Received: by 10.103.84.21 with SMTP id m21mr5433561mul.106.1269525765112;
	Thu, 25 Mar 2010 07:02:45 -0700 (PDT)
Received: from [192.168.1.5] (bzq-84-109-195-101.red.bezeqint.net
	[84.109.195.101])
	by mx.google.com with ESMTPS id b9sm7192327mug.13.2010.03.25.07.02.44
	(version=SSLv3 cipher=RC4-MD5); Thu, 25 Mar 2010 07:02:44 -0700 (PDT)
Message-ID: <4BAB6D03.7010905@gmail.com>
Date: Thu, 25 Mar 2010 16:02:43 +0200
From: David Harel <hareldvd@gmail.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: postgresql <pgsql-sql@postgresql.org>
Subject: Capacity planning.
Content-Type: multipart/alternative;
	boundary="------------040204060108000003040009"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/184
X-Sequence-Number: 33891

This is a multi-part message in MIME format.
--------------040204060108000003040009
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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 7657645
Cellular:   +972 54 4534502
Snail Mail: Amuka
            D.N Merom Hagalil
            13802
            Israel
Email:      hareldvd@ergolight-sw.com



--------------040204060108000003040009
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
<head>
</head>
<body style="direction: ltr;" bgcolor="#ffffff" text="#000000">
<p style="margin-bottom: 0cm; margin-top: 0pt;"><font size="+1"><font
 face="Arial">Hi,</font></font></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<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><span style="font-size: 18px;"></span></p>
<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,000 clients making
around 200 transactions a day each.<br>
</font></span><span style="font-size: 18px;"></span></p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<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>
</body>
</html>

--------------040204060108000003040009--



From bruce@momjian.us Wed Mar  31 14:47:46 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 8505F633A9B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <bruce@momjian.us>
Message-Id: <201003311447.o2VElLC19795@momjian.us>
Subject: Re: Capacity planning.
In-Reply-To: <4BAB6D03.7010905@gmail.com>
To: David Harel <hareldvd@gmail.com>
Date: Wed, 31 Mar 2010 10:47:21 -0400 (EDT)
CC: postgresql <pgsql-sql@postgresql.org>
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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com



From bnichols@ca.afilias.info Thu Apr  1 13:13:18 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id A1C59633B56
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  1 Apr 2010 10:13:18 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 05015-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  1 Apr 2010 13:12:58 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from outbound.afilias.info (outbound.afilias.info [69.46.124.26])
	by mail.postgresql.org (Postfix) with ESMTP id 76C95634051
	for <pgsql-sql@postgresql.org>; Thu,  1 Apr 2010 10:12:54 -0300 (ADT)
Received: from ms5.yyz2.afilias-ops.info ([10.50.129.111]
	helo=smtp.afilias.info)
	by outbound.afilias.info with esmtp (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>)
	id 1NxKCa-0006Oa-3s; Thu, 01 Apr 2010 13:12:52 +0000
Received: from tor-gateway.afilias.info ([199.15.87.4] helo=[10.10.46.12])
	by smtp.afilias.info with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69)
	(envelope-from <bnichols@ca.afilias.info>)
	id 1NxKCa-0004EL-3V; Thu, 01 Apr 2010 13:12:52 +0000
Subject: Re: Capacity planning.
From: Brad Nicholson <bnichols@ca.afilias.info>
To: David Harel <hareldvd@gmail.com>
Cc: postgresql <pgsql-sql@postgresql.org>
In-Reply-To: <4BAB6D03.7010905@gmail.com>
References: <4BAB6D03.7010905@gmail.com>
Content-Type: text/plain
Date: Thu, 01 Apr 2010 09:12:51 -0400
Message-Id: <1270127571.5155.315.camel@bnicholson-desktop>
Mime-Version: 1.0
X-Mailer: Evolution 2.26.1 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.683 tagged_above=-10 required=5 tests=AWL=-0.684,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 201004/1
X-Sequence-Number: 33928

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.