Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Stored procedure slower than sql?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Matthew Peters" <matthew(at)haydrian(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Stored procedure slower than sql?
- Date: Thu, 26 Oct 2006 12:14:38 -0400
"Matthew Peters" <matthew(at)haydrian(dot)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
- Follow-Ups:
- Re: Stored procedure slower than sql?
- From: Matthew Peters
- Re: Stored procedure slower than sql?
- References:
- Stored procedure slower than sql?
- From: Matthew Peters
- Stored procedure slower than sql?
- Prev by Date: Stored procedure slower than sql?
- Next by Date: Re: Stored procedure slower than sql?
- Previous by thread: Stored procedure slower than sql?
- Next by thread: Re: Stored procedure slower than sql?
- Indexes: