Re: concurrent inserts into two separate tables are very slow

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Sergei Shelukhin" <realgeek(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: concurrent inserts into two separate tables are very slow
Date: 2008-01-07 22:17:19
Message-ID: dcc563d10801071417qc0a5330hebbc390899ccb132@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Jan 5, 2008 9:00 PM, Sergei Shelukhin <realgeek(at)gmail(dot)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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-01-07 22:31:30 Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Previous Message Alvaro Herrera 2008-01-07 15:12:34 Re: Linux/PostgreSQL scalability issue - problem with 8 cores