R: Postgresql 12.x on Windows (vs Linux)
| От | Roberto Della Pasqua |
|---|---|
| Тема | R: Postgresql 12.x on Windows (vs Linux) |
| Дата | |
| Msg-id | AM0PR0502MB3650836EF6002C25848BF09B99E70@AM0PR0502MB3650.eurprd05.prod.outlook.com обсуждение исходный текст |
| Ответ на | Postgresql 12.x on Windows (vs Linux) (Robert Ford <robfordww@gmail.com>) |
| Ответы |
Re: R: Postgresql 12.x on Windows (vs Linux)
|
| Список | pgsql-general |
Well,
on Windows you should try ReiserFS over a nvme optimized WHQL certified hardware.
Da: Robert Ford <robfordww@gmail.com>
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 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?
best regards
RF
В списке pgsql-general по дате отправления: