Postgres Pro
Downloads
Home   >   mailing lists

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

From Sergei Shelukhin
Subject concurrent inserts into two separate tables are very slow
Date
Msg-id b6c58ae4-18fd-4dfb-bc8c-8d39150e04f7@n20g2000hsh.googlegroups.com
Whole thread Raw
Responses Re: concurrent inserts into two separate tables are very slow  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Next
From: "Scott Marlowe"
Date:
Subject: Re: concurrent inserts into two separate tables are very slow