dbTalk Databases Forums  

Re: [BUGS] PQexecParams performance

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] PQexecParams performance in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] PQexecParams performance - 12-12-2005 , 04:56 PM






"Harry Rossignol" <harrywr2 (AT) comcast (DOT) net> writes:
Quote:
My experience using PQexecParams is that it has a performance
degradation of a factor of 100's if not thousands.
This is demonstrably not so in general. You may be hitting a case where
the planner chooses a poor plan for lack of information about the value
of a parameter ... but with no details about the query or even mention
of which PG version you're talking about, this bug report isn't worth
the electrons it's written on.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.