From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Heavy contgnous load
Date: Thu, 20 Oct 2011 13:10:11 -0700 (PDT)
Message-ID: <1319141411977-4922748.post@n5.nabble.com> (raw)
In-Reply-To: <CAMkU=1yXGNzyFdAwzMVjJ11-P=Y-pF1cqjc2F1CtX7zRwrCyxQ@mail.gmail.com>
References: <1318939765661-4913425.post@n5.nabble.com>
<CAMkU=1yXGNzyFdAwzMVjJ11-P=Y-pF1cqjc2F1CtX7zRwrCyxQ@mail.gmail.com>
So guys, lot of thank you for all of the explanation and ideas!
Jeff Janes wrote:
> What happens if the database has a hiccup and can't accept records for
> a few seconds or minutes?
Craig Ringer wrote:
> If you really need absolutely maximum insert performance, you should
> just use a flat file or a different database system.
This need some explanation:
Just for easy explanation our system constructed by Pmodules called PMs. The
transport between PMs is a special reliable protocol with elastic high
capacity buffers. This absorb the peaks of asynchrnous event storm.
The related (small) part of our system called A_PM. This A_PM accept
asynchrnous event from many (can be more dozen) other PMs, format it and
store onto record of SQL table.
After the record inserted all must be open for complex querys requested by 3
or more PM.
Othersides we need to provide common public access to this records (and to
many other functions). This is why we use SQL database server for. But the
requirement is the user can be select freely the vendor of database server
from four database server set (one of is PGR). To implement this we have
twin interface.
The synchronous_commit=off and unlogged table are good idea. I try it.
The crash make mouch more trouble for our system than trouble generated by
loss of 200-300 record...
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Heavy-contgnous-load-tp4913425p4922748.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: <1319141411977-4922748.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