Postgres Pro
Downloads
Home   >   mailing lists

Execution Plan Cost - Mailing list pgsql-hackers

From Luis Vargas
Subject Execution Plan Cost
Date
Msg-id Prayer.1.2.0pre.0805081811580.32631@hermes-1.csi.cam.ac.uk
Whole thread Raw
Responses Re: Execution Plan Cost  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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. Can anyone give me any insight into what operations account 
for the extra execution time?

Thanks,

Luis Vargas

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proposed patch - psql wraps at window width
Next
From: Tom Lane
Date:
Subject: Re: Execution Plan Cost