Re: explain analyze rows=%.0f - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: explain analyze rows=%.0f
Date
Msg-id 1243950060.23910.58.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: explain analyze rows=%.0f  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: explain analyze rows=%.0f
List pgsql-hackers
On Mon, 2009-06-01 at 20:30 -0700, Ron Mayer wrote:

> What I'd find strange about "6.67 rows" in your example is more that on
> the estimated rows side, it seems to imply an unrealistically precise estimate
> in the same way that "667 rows" would seem unrealistically precise to me.
> Maybe rounding to 2 significant digits would reduce confusion?

You're right that the number of significant digits already exceeds the
true accuracy of the computation. I think what Robert wants to see is
the exact value used in the calc, so the estimates can be checked more
thoroughly than is currently possible.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: User-facing aspects of serializable transactions
Next
From: "Markus Wanner"
Date:
Subject: Re: PostgreSQL Developer meeting minutes up