Re: PL/pgSQL EXECUTE '..' USING with unknown

Поиск
Список
Период
Сортировка
От Cédric Villemain
Тема Re: PL/pgSQL EXECUTE '..' USING with unknown
Дата
Msg-id AANLkTi=fbc7XWEAeKAArhmXdwH8h9T0_1KXfWLqjK85a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL EXECUTE '..' USING with unknown  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PL/pgSQL EXECUTE '..' USING with unknown  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: Todays git migration results
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: security label support, part.2