From: kzsolt <kzsoltkzsolt@freemail.hu>
To: pgsql-performance@postgresql.org
Subject: Re: Heavy contgnous load
Date: Wed, 19 Oct 2011 11:55:35 -0700 (PDT)
Message-ID: <1319050535000-4919006.post@n5.nabble.com> (raw)
In-Reply-To: <4E9E204B.2040608@ringerc.id.au>
References: <1318939765661-4913425.post@n5.nabble.com>
<4E9E204B.2040608@ringerc.id.au>
"try to have as few indexes as possible and do your inserts inside
transactions in batches, rather than one-by-one as individual statements. "
That is the main problem. I use now few index as possible. Unfortunately the
one-by-one INSERT is nature of or system. To join (batch) inserts is require
spacial cache with inactivity timeout. But this timout are make more trouble
for our application. The flat file has same problem.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Heavy-contgnous-load-tp4913425p4919006.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: <1319050535000-4919006.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