RE: PgSQL 12 on WinSrv ~3x faster than on Linux

2021-06-04 Thread Taras Savchuk
> The first thing that comes to mind for me is fsync working correctly (i.e. > actually waiting for the disk write) in Linux but not in Windows. > On a weird VM stack like you've got, it's not hard for that sort of thing to > go > wrong. Needless to say, if that's the issue then the apparent perf

PgSQL 12 on WinSrv ~3x faster than on Linux

2021-06-04 Thread Taras Savchuk
x27;t make any difference. Contrary on Windows VM we have almost 3x better performance with stock PostgreSQL config. Any ideas what's wrong? For me such a big difference on identical databases/queries looks strange. -- Taras Savchuk