Re: Optimizing query?

2013/2/2 <hamann(dot)w(at)t-online(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general