Re: concurrent inserts into two separate tables are very slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jan 5, 2008 9:00 PM, Sergei Shelukhin <realgeek@xxxxxxxxx> 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?

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux