Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 28835632BF4 for ; 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 ; 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 ; Thu, 25 Mar 2010 11:02:47 -0300 (ADT) Received: by fxm24 with SMTP id 24so3127749fxm.3 for ; 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 User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: postgresql 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

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--