Re: [PERFORM] concurrent inserts into two separate tables are very slow

2008-01-07 Thread Scott Marlowe
On Jan 7, 2008 4:49 PM, Sergei Shelukhin <[EMAIL PROTECTED]> wrote: > > Scott Marlowe wrote: > > On Jan 5, 2008 9:00 PM, Sergei Shelukhin <[EMAIL PROTECTED]> wrote: > > > >> Hi. Running postgres 8.2 on debian. > >> I've noticed that concurrent inserts (archiving) of large batches data > >> into two

Re: [PERFORM] concurrent inserts into two separate tables are very slow

2008-01-07 Thread Sergei Shelukhin
Scott Marlowe wrote: On Jan 5, 2008 9:00 PM, Sergei Shelukhin <[EMAIL PROTECTED]> 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

Re: [PERFORM] concurrent inserts into two separate tables are very slow

2008-01-07 Thread Scott Marlowe
On Jan 5, 2008 9:00 PM, Sergei Shelukhin <[EMAIL PROTECTED]> 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 wa