concurrent inserts into two separate tables are very slow

From: Sergei Shelukhin <realgeek(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: concurrent inserts into two separate tables are very slow
Date: 2008-01-06 03:00:00
Message-ID: b6c58ae4-18fd-4dfb-bc8c-8d39150e04f7@n20g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jakub Ouhrabka 2008-01-07 11:00:12 Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Previous Message David Boreham 2008-01-04 20:55:08 Re: Linux/PostgreSQL scalability issue - problem with 8 cores