Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: Rocco Altier <RoccoA(at)Routescape(dot)com>, pgsql-patches(at)postgresql(dot)org,Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: [PATCH] Improve EXPLAIN ANALYZE overhead by sampling
Date: 2006-05-11 07:17:36
Message-ID: 20060511071736.GA30113@svana.org (view raw or flat)
Thread:
Lists: pgsql-patches
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(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

pgsql-patches by date

Next:From: Marko KreenDate: 2006-05-11 07:55:01
Subject: Re: BEGIN inside transaction should be an error
Previous:From: Tommi MaekitaloDate: 2006-05-11 06:05:57
Subject: Re: BEGIN inside transaction should be an error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group