Re: Hooks to Modify Execution Flow and Query Planner - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Hooks to Modify Execution Flow and Query Planner
Date
Msg-id bb99882d-80a0-39ab-931c-65331bcc6f0c@lab.ntt.co.jp
Whole thread Raw
In response to Re: Hooks to Modify Execution Flow and Query Planner  (Vincent Mirian <vince.mirian@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Getting ERROR: could not open file "base/13164/t3_16388" withpartition table with ON COMMIT
Next
From: Rajkumar Raghuwanshi
Date:
Subject: Re: Getting ERROR: could not open file "base/13164/t3_16388" withpartition table with ON COMMIT