Why insertion throughput can be reduced with an increase of batch size?

Поиск
Список
Период
Сортировка
От Павел Филонов
Тема Why insertion throughput can be reduced with an increase of batch size?
Дата
Msg-id CADcp+YCS1=EX+nNtcCWPTy3-BrT+XPJ3kwJkz_Fjp0hyvPRfKg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Why insertion throughput can be reduced with an increase of batch size?
Re: Why insertion throughput can be reduced with an increase of batch size?
Список pgsql-general
My greetings to everybody!

I recently faced with the observation which I can not explain. Why insertion throughput can be reduced with an increase of batch size?

Brief description of the experiment.

Experiment steps:

  • populate DB with 259200000 random records
  • start insertion for 60 seconds with one client thread and batch size = m
  • record insertions per second (ips) in clients code

Plot median ips from m for m in [2^0, 2^1, ..., 2^15] (in attachment).


On figure with can see that from m = 128 to m = 256 throughput have been reduced from 13 000 ips to 5000.

I hope someone can help me understand what is the reason for such behavior?

--
Best regards
Filonov Pavel
Вложения

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