Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Petr Praus <petr(at)praus(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Date: 2012-11-02 05:39:59
Message-ID: CAOR=d=3to4+6Ca9u-Sp8Rs4Yp=gMfa0AH+h6e56-pQqJ-tXqEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cesar Martin 2012-11-02 07:47:42 Re: High %SYS CPU usage
Previous Message Gunnar "Nick" Bluth 2012-11-01 23:25:16 Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries