Re: Parallel Seq Scan - Mailing list pgsql-hackers

From Thom Brown
Subject Re: Parallel Seq Scan
Date
Msg-id CAA-aLv4cPHaeGWZz3XW2rhrs=cBkf=F3SaW7acAreuSNeTmE7g@mail.gmail.com
Whole thread
In response to Re: Parallel Seq Scan  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Parallel Seq Scan
List pgsql-hackers
On 28 January 2015 at 14:03, Robert Haas <robertmhaas@gmail.com> wrote:
The problem here, as I see it, is that we're flying blind.  If there's
just one spindle, I think it's got to be right to read the relation
sequentially.  But if there are multiple spindles, it might not be,
but it seems hard to predict what we should do.  We don't know what
the RAID chunk size is or how many spindles there are, so any guess as
to how to chunk up the relation and divide up the work between workers
is just a shot in the dark.

Can't the planner take effective_io_concurrency into account?

Thom

pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: hung backends stuck in spinlock heavy endless loop
Next
From: Michael Paquier
Date:
Subject: Re: Safe memory allocation functions