Postgres Pro
Downloads
Home   >   mailing lists

Re: Indices and Foreign Tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Indices and Foreign Tables
Date
Msg-id 22463.1396635870@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indices and Foreign Tables  ("Kohler Manuel (ID SIS)" <manuel.kohler@id.ethz.ch>)
List pgsql-general
Tree view 
"Kohler  Manuel (ID SIS)" <manuel.kohler@id.ethz.ch> writes:
> here are the Query plans. The first plan is on the source database directly. So no fdw involved:

Do you have use_remote_estimate enabled?  The rowcount estimates for the
foreign tables seem pretty far from reality; use_remote_estimates should
help.

            regards, tom lane

pgsql-general by date:

Previous
From: "Kohler Manuel (ID SIS)"
Date:
Subject: Re: Indices and Foreign Tables
Next
From: Scott Marlowe
Date:
Subject: Re: SSD Drives