| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: productive usage of PostgreSQL with Windows Server |
| Date: | 2021-01-26 13:30:28 |
| Message-ID: | 0cfae453-28f8-0fe7-bae6-8dcea61c68ac@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2021-01-26 13:52:38 | Re: json_build_object, numeric types, and function limits on 100 arguments |
| Previous Message | Bo Victor Thomsen | 2021-01-26 13:01:11 | Re: productive usage of PostgreSQL with Windows Server |