From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | asp437(at)gmail(dot)com |
Cc: | a(dot)bykov(at)postgrespro(dot)ru, pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Optimze usage of immutable functions as relation |
Date: | 2018-10-24 03:02:45 |
Message-ID: | 20181024.120245.134697149.horiguchi.kyotaro@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello.
# It might be better that you provided self-contained test case.
As the discussion between Heikki and Tom just upthread, it would
be doable but that usage isn't typical. The query would be
normally written as followings and they are transformed as
desired.
select '|'||subject||'|', ts_rank_cd(body_tsvector,q) from
messages where body_tsvector @@ to_tsquery('tuple&header&overhead');
or (this doesn't look normal, thought..)
select '|'||subject||'|', ts_rank_cd(body_tsvector,q) from
messages, (select to_tsquery('tuple&header&overhead') as q) q
where body_tsvector @@ q;
This means that the wanted pull up logic is almost already
there. You should look on how it is handled.
At Sat, 20 Oct 2018 01:31:04 +0700, Aleksandr Parfenov <asp437(at)gmail(dot)com> wrote in <CACdpekK1oDy7-_HnXOaREa_8HM2r-fsp8iv5e6p8aWOdGdK8Mg(at)mail(dot)gmail(dot)com>
> Hi,
>
> Thank you for the review.
> I fixed a typo and some comments. Please find new version attached.
I had the following error with the following query.
=# explain select * from pg_stat_get_activity(NULL) a join log(100000.0) p on a.pid = p.p;
ERROR: no relation entry for relid 2
As Andrew pointed, you are missing many things to do.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2018-10-24 03:24:55 | Re: Log timestamps at higher resolution |
Previous Message | Bruno Wolff III | 2018-10-24 01:23:14 | Should pg 11 use a lot more memory building an spgist index? |