From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Subject: Heavy contgnous load
Date: Tue, 18 Oct 2011 05:09:25 -0700 (PDT)
Message-ID: <1318939765661-4913425.post@n5.nabble.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kzsoltkzsolt@freemail.hu
Subject: Re: Heavy contgnous load
In-Reply-To: <1318939765661-4913425.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox