Re: concurrent inserts into two separate tables are very slow

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: concurrent inserts into two separate tables are very slow
Дата
Msg-id dcc563d10801071417qc0a5330hebbc390899ccb132@mail.gmail.com
обсуждение исходный текст
Ответ на concurrent inserts into two separate tables are very slow  (Sergei Shelukhin <realgeek@gmail.com>)
Ответы Re: concurrent inserts into two separate tables are very slow
Список pgsql-performance
Дерево обсуждения 
On Jan 5, 2008 9:00 PM, Sergei Shelukhin <realgeek@gmail.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?

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

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