Re: [ADMIN] pgbench Windows outperforms Debian in Write tests whileDebian is faster in SELECT only tests

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [ADMIN] pgbench Windows outperforms Debian in Write tests whileDebian is faster in SELECT only tests
Дата
Msg-id 20170529181429.4hicimoro6jqog3s@alap3.anarazel.de
обсуждение исходный текст
Ответ на [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests  ("Klaus P. Pieper" <kpi6288@gmail.com>)
Ответы Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests  ("Klaus P. Pieper" <kpi6288@gmail.com>)
Список pgsql-admin
On 2017-05-29 09:42:53 +0200, Klaus P. Pieper wrote:
> Mounting the file system with barriers=0 gives much better results on the
> Debian system (better than the Windows system). But since this machine does
> not have a battery buffered disk adapter, that wouldn't be an option for a
> production system.

> I'm in particular concerned about the disadvantage in the single client
> WRITE scenario running Debian. How can Windows outperform Debian by a factor
> of 2?

Windows IIRC defaults to something close to barriers=0.

- Andres


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

Предыдущее
От: stevenchang1213
Дата:
Сообщение: [ADMIN] citus extension
Следующее
От: "Klaus P. Pieper"
Дата:
Сообщение: Re: [ADMIN] pgbench Windows outperforms Debian in Write tests while Debian is faster in SELECT only tests