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

From Claudio Freire
Subject Re: Parallel Select query performance and shared buffers
Date
Msg-id CAGTBQpYE3oRUfrt+++E-AFenfnnC8tRZie-Gf7fZHkV48Cwxyg@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Select query performance and shared buffers  (Metin Doslu <metin@citusdata.com>)
List pgsql-performance
On Tue, Dec 3, 2013 at 1:24 PM, Metin Doslu <metin@citusdata.com> wrote:
> Looking into syncscan.c, it says in comments:
>
> "When multiple backends run a sequential scan on the same table, we try to
> keep them synchronized to reduce the overall I/O needed."
>
> But in my workload, every process was running on a different table.

Ah, ok, so that's what you meant by "independent tables".


pgsql-performance by date:

Previous
From: Metin Doslu
Date:
Subject: Re: Parallel Select query performance and shared buffers
Next
From: Jan Michel
Date:
Subject: Re: One query run twice in parallel results in huge performance decrease