Re: Increasing parallelism of queries while using file fdw andpartitions - Mailing list pgsql-performance

From Justin Pryzby
Subject Re: Increasing parallelism of queries while using file fdw andpartitions
Date
Msg-id 20181219065149.GF8042@telsasoft.com
Whole thread Raw
In response to Increasing parallelism of queries while using file fdw and partitions  (Patrick Mulrooney <mulroony@gmail.com>)
Responses Re: Increasing parallelism of queries while using file fdw and partitions  (Patrick Mulrooney <mulroony@gmail.com>)
List pgsql-performance
On Tue, Dec 18, 2018 at 08:39:36PM -0800, Patrick Mulrooney wrote:
> Wondering if anyone had any thoughts on how to tweak my setup to get it to
> read many files at once instead of one at a time when using file fdw and
> partitions.

I found this:

https://www.postgresql.org/docs/current/parallel-safety.html
|The following operations are always parallel restricted.
|Scans of foreign tables, unless the foreign data wrapper has an IsForeignScanParallelSafe API which indicates
otherwise.

https://github.com/ergo70/vcf_fdw/blob/master/vcf_fdw/__init__.py
=> has no such API marker, since it's couple years old, same as multicorn.

Justin


pgsql-performance by date:

Previous
From: David Rowley
Date:
Subject: Re: SQL Perfomance during autovacuum
Next
From: Patrick Mulrooney
Date:
Subject: Re: Increasing parallelism of queries while using file fdw and partitions