subject:"Re\: \[GENERAL\] \[PERFORM\] Why Postgres use a little memory on Windows."

Re: [GENERAL] [PERFORM] Why Postgres use a little memory on Windows.

2016-02-21 Thread tuanhoanganh

Thanks for all help of everyone. I have tried to change effective_cache_size = 24GB and it run well. Tuan Hoang Anh

Re: [GENERAL] [PERFORM] Why Postgres use a little memory on Windows.

2016-02-20 Thread Jeff Janes

On Sat, Feb 20, 2016 at 8:46 AM, tuanhoanganh wrote: > Hello > > I have a bad query on PostgreSQL 9.0.23 - 64bit - Windows 2012 R2 - 48GB Ram 9.0 is no longer supported. You should work toward upgrading to a newer version. It might not solve this problem, but it would give you better tools for