How about
with par_ as (select * from product_parent where parent_name like 'aa%' )
select distinct product_code from product p_
inner join par_ on p_.parent_id=par_.id
limit 2
?
2012/4/3 Istvan Endredy
> Hi,
>
> i've ran into a planning problem.
>
>
> select distinct product_code from produc
Hi,
thanks for the suggestion, but it didn't help. We have tried it earlier.
7500ms
http://explain.depesz.com/s/ctn
ALTER TABLE product_parent ALTER COLUMN parent_name SET STATISTICS 1000;
ALTER TABLE product ALTER COLUMN parent_id SET STATISTICS 1000;
ANALYZE product_parent;
ANALYZE product;
q
On Mon, Apr 16, 2012 at 10:31 AM, Glyn Astill wrote:
>> From: Scott Marlowe
>>On Mon, Apr 16, 2012 at 8:13 AM, Cesar Martin wrote:
>>> Hi,
>>>
>>> Finally the problem was BIOS configuration. DBPM had was set to "Active
>>> Power Controller" I changed this to "Max
>>> Performance". http://en.comm
> From: Scott Marlowe
>On Mon, Apr 16, 2012 at 8:13 AM, Cesar Martin wrote:
>> Hi,
>>
>> Finally the problem was BIOS configuration. DBPM had was set to "Active
>> Power Controller" I changed this to "Max
>> Performance". http://en.community.dell.com/techcenter/power-cooling/w/wiki/best-practices
On Mon, Apr 16, 2012 at 10:08 AM, Merlin Moncure wrote:
> On Mon, Apr 16, 2012 at 10:45 AM, Scott Marlowe
> wrote:
>> On Mon, Apr 16, 2012 at 8:13 AM, Cesar Martin wrote:
>>> Hi,
>>>
>>> Finally the problem was BIOS configuration. DBPM had was set to "Active
>>> Power Controller" I changed this
2012/4/16 Tomek Walkuski
> Hello group!
>
> I have query like this:
>
> SELECT
> employments.candidate_id AS candidate_id,
> SUM(TS_RANK(employers.search_vector, TO_TSQUERY('simple', 'One:* |
> Two:* | Three:* | Four:*'), 2)) AS ts_rank
> FROM
> employments
> INNER JOIN
> employers ON employm
