Re: Execution Plan Cost - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Execution Plan Cost
Date
Msg-id 4197.1210267176@sss.pgh.pa.us
Whole thread Raw
In response to Execution Plan Cost  (Luis Vargas <Luis.Vargas@cl.cam.ac.uk>)
List pgsql-hackers
Luis Vargas <Luis.Vargas@cl.cam.ac.uk> writes:
> At the backend, I'm measuring the cost of executing (via SPI_execute_plan) 
> the read-only plan of a simple query with no reference to tables. E.g. 
> simpleplan(int) AS SELECT $1 > 5

> Executing this plan via SPI_execute takes around 70% more time than 
> directly executing the relevant operator function (int4gt) and using 
> DatumGetBool.

Only that much?  I'd have expected it to be several hundred times
slower, considering that int4gt is an utterly trivial function and
executor startup/shutdown is a fairly heavyweight operation.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Luis Vargas
Date:
Subject: Execution Plan Cost
Next
From: Josh Berkus
Date:
Subject: Re: Auto-updated fields