concurrent inserts into two separate tables are very slow

Поиск
Список
Период
Сортировка
От Sergei Shelukhin
Тема concurrent inserts into two separate tables are very slow
Дата
Msg-id b6c58ae4-18fd-4dfb-bc8c-8d39150e04f7@n20g2000hsh.googlegroups.com
обсуждение исходный текст
Ответы Re: concurrent inserts into two separate tables are very slow
Список 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?

В списке pgsql-performance по дате отправления: