Re: productive usage of PostgreSQL with Windows Server

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: productive usage of PostgreSQL with Windows Server
Дата
Msg-id 0cfae453-28f8-0fe7-bae6-8dcea61c68ac@gmx.net
обсуждение исходный текст
Ответ на productive usage of PostgreSQL with Windows Server  (Dirk Krautschick <Dirk.Krautschick@trivadis.com>)
Ответы AW: productive usage of PostgreSQL with Windows Server
Список pgsql-admin
Dirk Krautschick schrieb am 26.01.2021 um 12:20:
> I am aware and I always surely recommend Linux but the matter of fact that there
> are also customers with more Windows knowledge inhouse I always get the question
> about experience and references which I cannot provide at this time.
>
> Regarding the build farm status I see that it is pretty much tested and suppported at
> least. But I am interessted in fundational opinions and expierences.

I think the biggest drawback is that many useful tools and extensions are only
available on Linux. For some tools, it might be possible to compile them on Windows,
but it's not as easy and straightforward as doing that on Linux.

Your choice of e.g. backup tools (beyond the built-in tools) is also limited. I think
the only one is pgProBackup - at least it contains information on how to compile
it on Windows.

In my experience, NTFS on Windows doesn't perform as good the alternatives on Linux,
so performance on identical hardware is probably a bit lower when using Windows.

Thomas



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

Предыдущее
От: Bo Victor Thomsen
Дата:
Сообщение: Re: productive usage of PostgreSQL with Windows Server
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: json_build_object, numeric types, and function limits on 100 arguments