Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling

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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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