Re: PL/pgSQL EXECUTE '..' USING with unknown - Mailing list pgsql-hackers

From Cédric Villemain
Subject Re: PL/pgSQL EXECUTE '..' USING with unknown
Date
Msg-id AANLkTi=fbc7XWEAeKAArhmXdwH8h9T0_1KXfWLqjK85a@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL EXECUTE '..' USING with unknown  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PL/pgSQL EXECUTE '..' USING with unknown  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
List pgsql-hackers
2010/8/17 Tom Lane <tgl@sss.pgh.pa.us>:
> Cédric Villemain <cedric.villemain.debian@gmail.com> writes:
>> 2010/8/16 Tom Lane <tgl@sss.pgh.pa.us>:
>>> Cédric Villemain <cedric.villemain.debian@gmail.com> writes:
>>>> Unfortunely the current implementation of EXECUTE USING is not working
>>>> this way.
>>>
>>> Uh ... what do you base that statement on?
>
>> About the planning behavior ?
>> With USING, I get a seqscan (cost and long), without USING I have an
>> indexscan(short and costless).
>
> It works as expected for me.  What PG version are you using exactly?
> Could you provide a self-contained example?

postgresql 8.4.4. Yes I'll work one out this evening.
more or less : table foo (uid char(32) PK, flag boolean), uids are
md5sum. +-6M rows.
--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: Todays git migration results
Next
From: "Kevin Grittner"
Date:
Subject: Re: security label support, part.2