Re: Faster inserts with mostly-monotonically increasing values

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: Faster inserts with mostly-monotonically increasing values
Дата
Msg-id CABOikdMTXRXFktisupW=iAxJTSXOkazbFLoH-d7ESFKTfmGokw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Faster inserts with mostly-monotonically increasing values  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Faster inserts with mostly-monotonically increasing values  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


On Thu, Mar 15, 2018 at 7:51 AM, Claudio Freire <klaussfreire@gmail.com> wrote:


I applied the attached patches on top of your patch, so it would be
nice to see if you can give it a try in your test hardware to see
whether it helps.

I can confirm that I no longer see any regression at 8 or even 16 clients. In fact, the patched version consistent do better than master even at higher number of clients.

The only thing I am a bit puzzled is that I am no longer able to reproduce the 40-50% gains that I'd earlier observed with a single client. I now get 20-25% with smaller number of client and 10-15% with larger number of clients. I haven't been able to establish why it's happening, but since it's a different AWS instance (though of the same type), I am inclined to blame it on that for now.

Thanks,
Pavan

--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: [HACKERS] GUC for cleanup indexes threshold.
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Faster inserts with mostly-monotonically increasing values