WAL + SSD = slow inserts?

Поиск
Список
Период
Сортировка
От Skarsol
Тема WAL + SSD = slow inserts?
Дата
Msg-id CAMt8e=Ee9BRLvNk3qq3vw-KKu-myMOpbx+9y4ABQee1dLcTq7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: WAL + SSD = slow inserts?  (desmodemone <desmodemone@gmail.com>)
Re: WAL + SSD = slow inserts?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
I'm trying to increase the speed of inserts in a database that is on a not super fast storage system. I have installed a pair of SSDs and placed pg_xlog on them but am still getting inserts that take up to a second to complete, with .3 seconds being about average. Iostat doesn't show the SSDs stressed at all, and changing synchronous_commit doesn't seem to affect it one way or the other. Where would I look next for what could be causing the delay?

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

Предыдущее
От: salah jubeh
Дата:
Сообщение: Re: Explain analyze time overhead
Следующее
От: desmodemone
Дата:
Сообщение: Re: WAL + SSD = slow inserts?