Re: Extensible executor nodes for preparation of SQL/MED - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: Extensible executor nodes for preparation of SQL/MED
Date
Msg-id AANLkTikF7A4WXw+GTjVaG9PqFs0sC7rokwgfWGmviS2Z@mail.gmail.com
Whole thread Raw
In response to Re: Extensible executor nodes for preparation of SQL/MED  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: Extensible executor nodes for preparation of SQL/MED
List pgsql-hackers
Here is a WIP patch to extensible executor nodes.

It replaces large switch blocks with function-pointer calls (renamed to
PlanProcs from VTable). It has small performance win (Please test it!)
and capsulize some details of executor nodes, but is not perfect.

The infrastructure might be used by SQL/MED, but then not only PlanState
but also Plan and Path are required to be customizable. Complete cleanup
would be difficult, but I'm trying to find common ground for existing
postgres' implementation and extensible planner and executor.
Comments and suggestions welcome.


On Tue, Oct 26, 2010 at 12:21 PM, Itagaki Takahiro
<itagaki.takahiro@gmail.com> wrote:
> I didn't intend performance, but there is small but measurable win
> in it if I avoided indirections. We might not always need to copy
> a whole vtable into planstate; only ExecProcNode might be enough.
> I'll continue the research.
>
> 24957.767 ms : master (a big switch)
> 25059.838 ms : two indirections (planstate->plan->vtable->fn)
> 24819.298 ms : one indirection (planstate->plan->vtable.fn)
> 24118.436 ms : direct call (planstate->vtable.fn)
>
> So, major benefits of the change might be performance and code refactoring.
> Does anyone have comments about it for the functionality? It might also be
> used by SQL/MED and executor hooks, but I have no specific idea yet.


--
Itagaki Takahiro

Attachment

pgsql-hackers by date:

Previous
From: Greg
Date:
Subject: Re: Composite Types and Function Parameters
Next
From: Dean Rasheed
Date:
Subject: Re: Tab completion for view triggers in psql