Re: Initdb --data-checksums by default

Поиск
Список
Период
Сортировка
От Alex Ignatov
Тема Re: Initdb --data-checksums by default
Дата
Msg-id 5719FE86.7020209@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Initdb --data-checksums by default  (Vick Khera <vivek@khera.org>)
Список pgsql-general


On 21.04.2016 20:26, Vick Khera wrote:

On Thu, Apr 21, 2016 at 9:00 AM, Alex Ignatov <a.ignatov@postgrespro.ru> wrote:
Ms Windows doesnt have ZFS support. AIX also doesnt. Z/OS also.  Any other commercial Linux distros don't have ZFS support. Yes you can compile it and use on production but...
But PG runs on the above OS, but have check sum off by default. Thats the deal. And it is not related to ZFS existence or any other FS with checksums in any way. The question is only in performance hit when you turn it on and  now I am in the process of testing it...

I don't care about those platforms, so changing the default is just making more work for me. :)
I see ;). By  the way following my tests turn this option on is only 1-2% overhead in throughput.
-- 
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

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

Предыдущее
От: David Goodenough
Дата:
Сообщение: Re: Proper relational database?
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: different empty array syntax requirements