Execution Plan Cost

From: Luis Vargas <Luis(dot)Vargas(at)cl(dot)cam(dot)ac(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Execution Plan Cost
Date: 2008-05-08 17:11:58
Message-ID: Prayer.1.2.0pre.0805081811580.32631@hermes-1.csi.cam.ac.uk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-05-08 17:19:36 Re: Execution Plan Cost
Previous Message Bruce Momjian 2008-05-08 17:08:33 Re: Proposed patch - psql wraps at window width