Hi, the main drawback in my eyes ist he concept of the OS. In Unix/Linux you can use really great files and pipe the data from/into processes optional by changing stuff on the fly (sed). Even GB and TB are no problem. Done this many times. (AIX, SGI, SUSE, DEBIAN etc) I often see that Windows user chunk their data into smaller peaces because of main memory limited tools. regards, Anton -----Ursprüngliche Nachricht----- Von: Thomas Kellerer <shammat@xxxxxxx> Gesendet: Dienstag, 26. Januar 2021 14:30 An: pgsql-admin@xxxxxxxxxxxxxxxxxxxx Betreff: Re: productive usage of PostgreSQL with Windows Server 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
