Postgres Pro
Downloads
Home   >   mailing lists

Re: Stored procedure slower than sql? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Stored procedure slower than sql?
Date
Msg-id 21413.1161879278@sss.pgh.pa.us
Whole thread Raw
In response to Stored procedure slower than sql?  ("Matthew Peters" <matthew@haydrian.com>)
Responses Re: Stored procedure slower than sql?  ("Matthew Peters" <matthew@haydrian.com>)
List pgsql-performance
Tree view 
"Matthew Peters" <matthew@haydrian.com> writes:
> How can a stored procedure containing a single query not implement the
> same execution plan (assumption based on the dramatic performance
> difference) that an identical ad-hoc query generates?

Parameterized vs non parameterized query?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Matthew Peters"
Date:
Subject: Stored procedure slower than sql?
Next
From: "Matthew Peters"
Date:
Subject: Re: Stored procedure slower than sql?