Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: parametrized statements, but always replan?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Dave Cramer <pg(at)fastcrypt(dot)com>
- Cc: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>, pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: parametrized statements, but always replan?
- Date: Thu, 21 Dec 2006 00:42:22 -0500
Dave Cramer <pg(at)fastcrypt(dot)com> writes: > The only time prepared statements won't replan is if you re-use the > prepared statement, which your code does not. > However... AFAIK, postgresql does not plan based on the parameter. This was changed in 8.2: for an unnamed statement the planning step is delayed until Bind time, so that the actual parameter values can be considered. regards, tom lane
- References:
- parametrized statements, but always replan?
- From: Kevin Murphy
- Re: parametrized statements, but always replan?
- From: Dave Cramer
- parametrized statements, but always replan?
- Prev by Date: State of the art in large scale inserts
- Next by Date: ant specif task for pg_dump and pg_restore
- Previous by thread: Re: parametrized statements, but always replan?
- Next by thread: Re: parametrized statements, but always replan?
- Indexes: