Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling - Mailing list pgsql-patches

From Martijn van Oosterhout
Subject Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling
Date
Msg-id 20060511071736.GA30113@svana.org
Whole thread Raw
In response to Re: [PATCH] Improve EXPLAIN ANALYZE overhead by  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: [PATCH] Improve EXPLAIN ANALYZE overhead by
List pgsql-patches
Tree view 
On Wed, May 10, 2006 at 09:16:43PM -0700, Luke Lonergan wrote:
> Nice one Martijn - we have immediate need for this, as one of our sizeable
> queries under experimentation took 3 hours without EXPLAIN ANALYZE, then
> over 20 hours with it...

Did you test it? There are some cases where this might still leave some
noticable overhead (high loop count). I'm just not sure if they occur
all that often in practice...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

pgsql-patches by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: [PATCH] Improve EXPLAIN ANALYZE overhead by
Next
From: "Luke Lonergan"
Date:
Subject: Re: [PATCH] Improve EXPLAIN ANALYZE overhead by