Re: Do parallel queries work with only dblink not with fdw? - Mailing list pgsql-general

From kpi6288
Subject Re: Do parallel queries work with only dblink not with fdw?
Date
Msg-id 009b01d1a60e$a0e5e930$e2b1bb90$@gmail.com
Whole thread Raw
In response to Re: Do parallel queries work with only dblink not with fdw?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
> -----Ursprüngliche Nachricht-----
> Von: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
>
> I am not sure of the status of parallel query in FDW, but for those that are some
> more information would be helpful:
>
> 1) You are using postgres_fdw, correct?

Yes.

>
> 2) What version of the FDW are you using?

Not sure if FDW could be different from the cluster version (see below). Postgres_fdw.dll shows file version
9.5.2.16088- this is the one installed with the Windows PostgreSQL package. 

>
> 3) What version(s) of Postgres are you connecting from/to?

For testing I have installed a fresh download 9.5.2 Windows x64 (on Windows Server 2008 R2, if this is of interest)

There is only one test database running in this cluster. I am connecting in a "loopback" mode to that database.

I could repeat my tests with two different databases or run it on a Linux / Debian machine if that makes a difference.

Thanks Klaus






pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Thoughts on "Love Your Database"
Next
From: Marc Mamin
Date:
Subject: Re: Do parallel queries work with only dblink not with fdw?