Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7D7CA63480D for ; Fri, 20 Mar 2009 06:31:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 02686-04 for ; Fri, 20 Mar 2009 06:31:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from eu3sys201aog001.obsmtp.com (eu3sys201aog001.obsmtp.com [207.126.148.181]) by mail.postgresql.org (Postfix) with SMTP id E183B6335CF for ; Fri, 20 Mar 2009 06:31:28 -0300 (ADT) Received: from source ([89.110.131.243]) by eu3sys201aob001.postini.com ([207.126.154.11]) with SMTP ID DSNKScNibvOCChzgdYjm5EOYUrZOeNwU5F5N@postini.com; Fri, 20 Mar 2009 09:31:28 UTC Received: from [192.168.178.59] (pD9E4A101.dip0.t-ipconnect.de [217.228.161.1]) by nemo.xenovation.com (Postfix) with ESMTP id 575F211D021C for ; Fri, 20 Mar 2009 10:26:24 +0100 (CET) Message-ID: <49C36145.1080909@bortal.de> Date: Fri, 20 Mar 2009 10:26:29 +0100 From: "ml@bortal.de" User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: current transaction in productive database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/286 X-Sequence-Number: 33208 Hello List, is there a way to find out, how many transactions my currenc productive database is doing? I know know how much i an offer with my new database and hardware, but i would also like to know what i actually _need_ on my current productive system. Is there a way to find this out? Cheers, Mario