Re: patch: SQL/MED(FDW) DDL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: patch: SQL/MED(FDW) DDL
Date
Msg-id 23621.1286288719@sss.pgh.pa.us
Whole thread Raw
In response to Re: patch: SQL/MED(FDW) DDL  (Shigeru HANADA <hanada@metrosystems.co.jp>)
Responses Re: patch: SQL/MED(FDW) DDL
List pgsql-hackers
Shigeru HANADA <hanada@metrosystems.co.jp> writes:
> Can we treat statistics of a foreign table separately?

> 1. Same as local tables (maybe required)
>    (pg_statistic.*, pg_class.reltuples/relpages)

This whole discussion seems to me to be about trying to do things outside
the FDW that should properly be left inside the FDW.  Who's to say that
the remote side even *has* statistics of the sort that PG creates?

We should provide an API that lets the FDW return a cost estimate for a
proposed access path.  Where it gets the cost estimate from is not
something that should be presupposed.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: standby registration (was: is sync rep stalled?)
Next
From: Robert Haas
Date:
Subject: Re: patch: SQL/MED(FDW) DDL