Message-ID: <44738A49.2010504@ca.sophos.com>
Date: Tue, 23 May 2006 15:18:49 -0700
From: Mischa Sandberg <mischa@ca.sophos.com>
Reply-To: mischa@ca.sophos.com
User-Agent: Thunderbird 1.5.0.2 (X11/20060420)
MIME-Version: 1.0
To: Dan Gorman <dgorman@hi5.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Selects query stats?
References: <9C4E40CF-6C06-4297-AF32-A7EF2A3F3C0F@hi5.com>
	<4473512E.7020805@ca.sophos.com>
	<82252882-2A15-4823-A517-7AB3161889D1@hi5.com>
	<4473553C.1010804@ca.sophos.com>
	<127D68F6-7620-4A62-8D1A-9B475E7571CD@hi5.com>
	<20060523184100.GW64371@pervasive.com>
	<17713.1148411593@sss.pgh.pa.us> <20060523195001.GH28863@surnet.cl>
In-Reply-To: <20060523195001.GH28863@surnet.cl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Alvaro Herrera wrote:
> Yeah, the problem seems underspecified.

So, Dan, the question is, what are you trying to measure?
This might be a statistic that management has always been given,
for Oracle, and you need to produce the "same" number for PostgreSQL.

If not, it's hard to figure out what a statement counter actually can measure,
to the extent that you can say, "If that number does THIS, I should do THAT."

-- 
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.