| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgresql 12.x on Windows (vs Linux) |
| Date: | 2020-03-02 14:57:54 |
| Message-ID: | be739b04-7bd8-87e2-92f7-3655e40b000f@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Robert Ford schrieb am 02.03.2020 um 15:42:
> I am aware that this might be a broad question, but I am not
> expecting *very *specific answers either:
>
> When it come to running a modern PostgreSQL server, which serves say
> 1 TB of data, are there substantial differences in performance
> between Windows Server 2019 and Linux today? I know there are some
> issues with shared_buffers and windows, but does it manifest in real
> performance issues?
>
> I have searched the web for this question, but is surprised to find
> very few concrete benchmarks on this. Anyone with real world
> experience on this topic?
I think the major Linux file systems do still outperform NTFS.
But you might want to consider something else:
Most of the interesting extensions and tools only work on Linux - that includes administration tools like barman, pg_back or repmgr.
So preferring one over the other, is not only about performance, but might also be about administration.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Della Pasqua | 2020-03-02 15:01:34 | R: Postgresql 12.x on Windows (vs Linux) |
| Previous Message | Robert Ford | 2020-03-02 14:42:15 | Postgresql 12.x on Windows (vs Linux) |