From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling |
Date: | 2006-05-12 09:57:58 |
Message-ID: | e41m79$292g$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
"Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote
>
> What it does behave normally for the first 50 tuples of any node, but
> after that it starts sampling at ever increasing intervals, the
> intervals controlled by an exponential function.
>
I got two questions after scanning the patch:
(1) For a node with 50 loops and another one 50+10^3 loops, the first
one will be measured 50 times and the second one will be measured 50+10
times? I am not sure if this is rational.
(2) Will this patch instruct multinode without interval? This is because
we always use ntuples=0 for multinode, so the tuplecount will not
change.
Maybe another way is to measure the cost of timing, then substruct it
from the result - but this is a hand-waiving only so far ...
Regards,
Qingqing
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-05-12 10:22:54 | Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling |
Previous Message | Thomas Hallgren | 2006-05-12 09:49:33 | any, anyelement, and anyarray |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-05-12 10:22:54 | Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling |
Previous Message | Matteo Beccati | 2006-05-12 08:02:08 | Re: [HACKERS] Enhanced containment selectivity function |