From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: David Wheeler <david@kineticode.com>
Subject: Re: Benchmarking Function
Date: Sun, 21 May 2006 12:23:49 -0700
Message-ID: <200605211223.49499.josh@agliodbs.com> (raw)
In-Reply-To: <1D5FC47D-8D90-4856-8EB7-833476A37587@kineticode.com>
References: <1D5FC47D-8D90-4856-8EB7-833476A37587@kineticode.com>
DW,
> The idea of the control is, of course, to subtract the overhead of
> the benchmarking function from the code actually being tested. So I
> guess my question is, how important is it to have the control there,
> and, if it is important, how should it actually work?
Well, per our conversation the approach doesn't really work. EXECUTE
'string' + generate_series seems to carry a substantial and somewhat random
overhead, between 100ms and 200ms -- enough to wipe out any differences
between queries.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, david@kineticode.com
Subject: Re: Benchmarking Function
In-Reply-To: <200605211223.49499.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox