Re: Optimizing query?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Optimizing query?
Дата
Msg-id CAFj8pRCCkLKptsY_cwDRBywTk-OGhPyofO5MFbhuL5UUR1SHZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimizing query?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
2013/2/2 Pavel Stehule <pavel.stehule@gmail.com>:
> 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
>>

seriously - it is typical solution - and it is great so PostgreSQL
help to you :)

Regards

Pavel

>
> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Optimizing query?
Следующее
От: Karel Riverón Escobar
Дата:
Сообщение: What language is faster, C or PL/PgSQL?