Postgres Pro
Downloads
Home   >   mailing lists

Re: concurrent inserts into two separate tables are very slow - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: concurrent inserts into two separate tables are very slow
Date
Msg-id dcc563d10801071417qc0a5330hebbc390899ccb132@mail.gmail.com
Whole thread Raw
In response to concurrent inserts into two separate tables are very slow  (Sergei Shelukhin <realgeek@gmail.com>)
Responses Re: concurrent inserts into two separate tables are very slow  (Sergei Shelukhin <realgeek@gmail.com>)
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Sergei Shelukhin
Date:
Subject: concurrent inserts into two separate tables are very slow
Next
From: Tom Lane
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores