Re: Hooks to Modify Execution Flow and Query Planner

Hi,

On 2018/11/03 17:28, Vincent Mirian wrote:
> Hi Amit,
>
> Thank you for your response. Chapters 51, 57 and 59 (Overview of PostgreSQL
> Internals, Writing A Foreign Data Wrapper and Writing A Custom Scan
> Provider) seem to be relevant. Aside from the source code snippets in the
> document, is there functional source code that can be used as reference?

You can look at contrib/postgres_fdw for an example of a quite functional
foreign data wrapper.

For examples of a custom scan provider, you can look at Citus [1],
pg-strom [2].

Citus, for example, implements plan nodes like MultiJoin, Job, etc. that
are not present in vanilla PostgreSQL to implement additional query
execution functionality.

Similarly, you can find custom nodes like GpuJoin in pg-strom.

> Also, aside from this mailing list, is there an interactive medium for
> asking questions?

There are IRC and Slack channels which you can access via the following page:

https://www.postgresql.org/community/

Thanks,
Amit

[1] https://github.com/citusdata/citus
[2] https://github.com/heterodb/pg-strom