Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0E465B5DC4B for ; Tue, 18 Oct 2011 09:29:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 16346-02 for ; Tue, 18 Oct 2011 12:29:11 +0000 (UTC) X-Greylist: delayed 00:19:44.270067 by SQLgrey-1.8.0-rc2 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id 4DBB2B5DC46 for ; Tue, 18 Oct 2011 09:29:11 -0300 (ADT) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1RG8U1-0006lP-Li for pgsql-performance@postgresql.org; Tue, 18 Oct 2011 05:09:25 -0700 Date: Tue, 18 Oct 2011 05:09:25 -0700 (PDT) From: kzsolt To: pgsql-performance@postgresql.org Message-ID: <1318939765661-4913425.post@n5.nabble.com> Subject: Heavy contgnous load MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201110/154 X-Sequence-Number: 45376 Dear Anybody! I use pgr to store records. But the characterisitc of the record traffic are special. For example 50 of them arrived in one sec contignously trough weeks and aligned interally trough tables. To absorb this traffic I put the pgr database to ramdisk (fast as possible). But after more day work the pgr slowing down. What is important think for this task I do not need any tranasction. So the COMMIT and ROLLBACK feature is useless. The question is how I minimize the rollback activity to free resoureces? Thanks for any idea. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Heavy-contgnous-load-tp4913425p4913425.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.