From: Petr Praus <petr@praus.net>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Date: Fri, 2 Nov 2012 09:09:52 -0500
Message-ID: <CACezXZ9aeCB2dUN7mO2NQk+GoPBXk4d1MorvpYDTDu9W3EWCJA@mail.gmail.com> (raw)
In-Reply-To: <CAOR=d=3to4+6Ca9u-Sp8Rs4Yp=gMfa0AH+h6e56-pQqJ-tXqEg@mail.gmail.com>
References: <CACezXZ_w7HbqSxZ=5SJH=kxb4nBDNbpDejttSaU6EC1AeO4PYg@mail.gmail.com>
<CAOR=d=3to4+6Ca9u-Sp8Rs4Yp=gMfa0AH+h6e56-pQqJ-tXqEg@mail.gmail.com>
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.marlowe@gmail.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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: petr@praus.net, scott.marlowe@gmail.com
Subject: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
In-Reply-To: <CACezXZ9aeCB2dUN7mO2NQk+GoPBXk4d1MorvpYDTDu9W3EWCJA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox