Postgres Pro
Downloads
Home   >   mailing lists

Re: Parallel Select query performance and shared buffers - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Parallel Select query performance and shared buffers
Date
Msg-id 20131203135323.GA5158@eldon.alvh.no-ip.org
Whole thread Raw
In response to Parallel Select query performance and shared buffers  (Metin Doslu <metin@citusdata.com>)
Responses Re: Parallel Select query performance and shared buffers  (Metin Doslu <metin@citusdata.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Metin Doslu
Date:
Subject: Parallel Select query performance and shared buffers
Next
From: Claudio Freire
Date:
Subject: Re: Parallel Select query performance and shared buffers