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  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: concurrent inserts into two separate tables are very slow