From: Scott Marlowe <scott.marlowe@gmail.com>
To: Sergei Shelukhin <realgeek@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: concurrent inserts into two separate tables are very slow
Date: Mon, 7 Jan 2008 16:17:19 -0600
Message-ID: <dcc563d10801071417qc0a5330hebbc390899ccb132@mail.gmail.com> (raw)
In-Reply-To: <b6c58ae4-18fd-4dfb-bc8c-8d39150e04f7@n20g2000hsh.googlegroups.com>
References: <b6c58ae4-18fd-4dfb-bc8c-8d39150e04f7@n20g2000hsh.googlegroups.com>
On Jan 5, 2008 9:00 PM, Sergei Shelukhin <realgeek@gmail.com> wrote:
> Hi. Running postgres 8.2 on debian.
> I've noticed that concurrent inserts (archiving) of large batches data
> into two completely unrelated tables are many times slower than the
> same inserts done in sequence.
> Is there any way to speed them up apart from buying faster HDs/
> changing RAID configuration?
What method are you using to load these data? Got a short example
that illustrates what you're doing?
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: scott.marlowe@gmail.com, realgeek@gmail.com
Subject: Re: concurrent inserts into two separate tables are very slow
In-Reply-To: <dcc563d10801071417qc0a5330hebbc390899ccb132@mail.gmail.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