Re: Optimizing query?

2013/2/2  <hamann.w@t-online.de>:
> Pavel Stehule wrote:
>
>>>
>>> but maybe  https://github.com/dimitri/prefix can help
>>>
>
> Hi Pavel,
>
> thanks - this works perfect. However, it does not seem to play well
> with the optimizer, so I ended up with
>
> select all candidates into a temp table using prefix operator
> apply all other conditions by joining that temp table to original ones
>

you can send  proposals to enhancing to Dimitry - He will be happy :)

Regards

Pavel

> Regards
> Wolfgang
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general