From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Metin Doslu <metin@citusdata.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Parallel Select query performance and shared buffers
Date: Tue, 3 Dec 2013 10:53:23 -0300
Message-ID: <20131203135323.GA5158@eldon.alvh.no-ip.org> (raw)
In-Reply-To: <CAL1dPcec7wMC9Z3VHrfO-2sEUqTH0Aawoi-JVJ3H45sQFFi3yA@mail.gmail.com>
References: <CAL1dPcec7wMC9Z3VHrfO-2sEUqTH0Aawoi-JVJ3H45sQFFi3yA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Metin Doslu wrote:
> When we send concurrent Select queries to these tables, query performance
> doesn't scale out with the number of CPU cores. We find that complex Select
> queries scale out better than simpler ones. We also find that increasing
> the block size from 8 KB to 32 KB, or increasing shared_buffers to include
> the working set mitigates the problem to some extent.
Maybe you could help test this patch:
http://www.postgresql.org/message-id/20131115194725.GG5489@awork2.anarazel.de
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: alvherre@2ndquadrant.com, metin@citusdata.com
Subject: Re: Parallel Select query performance and shared buffers
In-Reply-To: <20131203135323.GA5158@eldon.alvh.no-ip.org>
* 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