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

From: Petr Praus <petr(at)praus(dot)net>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
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 14:09:52
Message-ID: CACezXZ9aeCB2dUN7mO2NQk+GoPBXk4d1MorvpYDTDu9W3EWCJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I did run each query several times, the results I posted are for ~10th run
of the query.

The zone reclaim mode is 0.

On 2 November 2012 00:39, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:

> 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

Browse pgsql-performance by date

  From Date Subject
Next Message list, mailing 2012-11-02 14:39:02 freebsd or linux
Previous Message Pedro Jiménez Pérez 2012-11-02 12:13:52 help with too slow query