Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Execution Plan ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 9328 of 9685
Post > Topic >>

Execution Plan Cost

by Luis.Vargas@[EMAIL PROTECTED] (Luis Vargas) May 8, 2008 at 06:11 PM

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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 2 Posts in Topic:
Execution Plan Cost
Luis.Vargas@[EMAIL PROTEC  2008-05-08 18:11:58 
Re: Execution Plan Cost
tgl@[EMAIL PROTECTED] (T  2008-05-08 13:19:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 0:18:56 CDT 2008.