Re: Loaded footgun open_datasync on Windows

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Loaded footgun open_datasync on Windows
Дата
Msg-id 20180601185654.GD9004@paquier.xyz
обсуждение исходный текст
Ответ на Re: Loaded footgun open_datasync on Windows  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Loaded footgun open_datasync on Windows  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Fri, Jun 01, 2018 at 07:32:26PM +0200, Magnus Hagander wrote:
> Basically, this method *is* safe as long as you have proper storage. For
> example, if yo have a RAID controller with cache, it is perfectly safe. If
> you have a consumer level device with unsafe caching, then it's not safe.
> This behaves basically the same as it does on e.g. Linux, which is also
> unsafe if you have an unsafe conusmer device.

When things come to VMs or containers, developers and users tend to be
sloppy regarding the hardware being used, and they are not usually aware
that the database running within it is sensitive to such details.  Many
folks use Postgres, so IMO having defaults which are safe without
relying on hardware characteristics is a rather sensible approach. (Got
bitten by that in the past, not everybody is careful).  My 2c.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_replication_slot_advance to return NULL instead of 0/0 ifslot not advanced
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: documentation fixes for partition pruning, round two