Re: Do parallel queries work with only dblink not with fdw?

From: "kpi6288" <kpi6288(at)gmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Do parallel queries work with only dblink not with fdw?
Date: 2016-05-04 14:09:52
Message-ID: 009b01d1a60e$a0e5e930$e2b1bb90$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Ursprüngliche Nachricht-----
> Von: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2016-05-04 14:10:08 Re: Do parallel queries work with only dblink not with fdw?
Previous Message Melvin Davidson 2016-05-04 13:44:22 Re: Thoughts on "Love Your Database"