Optimizer + bind variables - Mailing list pgsql-performance

From David Kerr
Subject Optimizer + bind variables
Date
Msg-id 20091103174729.GA55736@mr-paradox.net
Whole thread Raw
Responses Re: Optimizer + bind variables
List pgsql-performance
Does/is it possible for the PG optimizer come up with differnet plans when
you're using bind variables vs when you send static values?

like  if my query was

select * from users (add a bunch of complex joins) where username = 'dave'
vs
select * from users (add a bunch of complex joins) where username = '?'

In oracle they are frequently different.

if it's possible for the plan to be different how can i generate an
xplan for the bind version?

Thanks!

Dave

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Problem with database performance, Debian 4gb ram ?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Problem with database performance, Debian 4gb ram ?