Re: Optimizing query?

From: hamann(dot)w(at)t-online(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizing query?
Date: 2013-02-02 09:17:08
Message-ID: wolfgang-1130202101708.A0312546@amadeus3.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Regards
Wolfgang

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-02-02 09:25:40 Re: Optimizing query?
Previous Message Jeff Janes 2013-02-02 01:21:54 Re: trouble with upgrade from 9.0 (many schemas and tables)