Re: Perf Benchmarking and regression.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Perf Benchmarking and regression.
Дата
Msg-id 3BD55B6E-A7B0-46E5-A684-9A76D7662515@anarazel.de
обсуждение исходный текст
Ответ на Re: Perf Benchmarking and regression.  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Ответы Re: Perf Benchmarking and regression.  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers

Hi,

On May 26, 2016 9:29:51 PM PDT, Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
>Hi All,
>
>As we have seen the regression of more than 45% with
>"*backend_flush_after*"
>enabled and set to its default value i.e. 128KB or even when it is set
>to
>some higher value like 2MB, i think we should disable it such that it
>does
>not impact the read write performance and here is the attached patch
>for
>the same.  Please have a look and let me know your thoughts on this.
>Thanks!

I don't think the situation is quite that simple. By *disabling* backend flushing it's also easy to see massive
performanceregressions.  In situations where shared buffers was configured appropriately for the workload (not the case
hereIIRC).
 

Andres
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.



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

Предыдущее
От: Ashutosh Sharma
Дата:
Сообщение: Re: Perf Benchmarking and regression.
Следующее
От: Piotr Stefaniak
Дата:
Сообщение: Re: pg_bsd_indent - improvements around offsetof and sizeof