Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread bret_stern
on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware. *Da:* Robert Ford *Inviato:* lunedì 2 marzo 2020 15:42 *A:*pgsql-general@lists.postgresql.org *Oggetto:* Postgresql 12.x on Windows (vs Linux) I am aware that this might be a broad question, but I am not expecting

Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Tim Clarke
gt; on Linux. Save your money. >>>> >>>> Tim Clarke >>>> IT Director >>>> Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 >>>> >>>> On 02/03/2020 15:01, Roberto Della Pasqua wrote: >>>>> Well, >>

Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Ron
44 (0)1376 504510 | Mobile: +44 (0)7887 563420 On 02/03/2020 15:01, Roberto Della Pasqua wrote: Well, on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware. *Da:* Robert Ford *Inviato:* lunedì 2 marzo 2020 15:42 *A:*pgsql-general@lists.postgresql.org *Oggetto:* Postgres

Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Tim Clarke
r a nvme optimized WHQL >>> certified hardware. >>> >>> *Da:* Robert Ford >>> *Inviato:* lunedì 2 marzo 2020 15:42 >>> *A:*pgsql-general@lists.postgresql.org >>> *Oggetto:* Postgresql 12.x on Windows (vs Linux) >>> >>> I am awa

Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Ron
marzo 2020 15:42 *A:* pgsql-general@lists.postgresql.org *Oggetto:* Postgresql 12.x on Windows (vs Linux) 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

Re: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Justin
Hi Robert I've used Postgresql on windows for years. Yes there are performance differences between windows and linux and the gap has gotten bigger with JIT Common performance hits Shared Buffers JIT not supported Windows can be aggressive flushing its disk cache, https://docs.microsoft.com/en-

Re: R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Tim Clarke
me optimized WHQL > certified hardware. > > *Da:* Robert Ford > *Inviato:* lunedì 2 marzo 2020 15:42 > *A:* pgsql-general@lists.postgresql.org > *Oggetto:* Postgresql 12.x on Windows (vs Linux) > > I am aware that this might be a broad question, but I am not expecting > *

R: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Roberto Della Pasqua
Well, on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware. Da: Robert Ford Inviato: lunedì 2 marzo 2020 15:42 A: pgsql-general@lists.postgresql.org Oggetto: Postgresql 12.x on Windows (vs Linux) I am aware that this might be a broad question, but I am not expecting

Re: Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Thomas Kellerer
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 > betwee

Postgresql 12.x on Windows (vs Linux)

2020-03-02 Thread Robert Ford
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