Postgres Pro
Downloads
Home   >   mailing lists

Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Date
Msg-id CAOR=d=3to4+6Ca9u-Sp8Rs4Yp=gMfa0AH+h6e56-pQqJ-tXqEg@mail.gmail.com
Whole thread Raw
In response to Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries  (Petr Praus <petr@praus.net>)
Responses Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
List pgsql-performance
Tree view 
Two possibilities:

caching.  make sure to run each query several times in a row.

zone reclaim mode. If this has gotten turned on turn it back off.

How to tell:

sysctl -n vm.zone_reclaim_mode

Output should be 0.  If it's not, then add this to /etc/sysctl.conf:

vm.zone_reclaim_mode=0

and run: sudo sysctl -p

and see if that helps.

pgsql-performance by date:

Previous
From: "Gunnar \"Nick\" Bluth"
Date:
Subject: Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Next
From: Cesar Martin
Date:
Subject: Re: High %SYS CPU usage