Re: explain analyze rows=%.0f
От
Simon Riggs
Тема
Re: explain analyze rows=%.0f
Дата
Msg-id
1243950060.23910.58.camel@ebony.2ndQuadrant
Ответ на
Re: explain analyze rows=%.0f (Ron Mayer)
Список
Дерево обсуждения
explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Euler Taveira de Oliveira <euler@timbira.com>
Re: explain analyze rows=%.0f Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: explain analyze rows=%.0f Simon Riggs <simon@2ndQuadrant.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f "David G. Johnston" <david.g.johnston@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Amit Kapila <amit.kapila16@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f vignesh C <vignesh21@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Greg Stark <stark@mit.edu>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Justin Pryzby <pryzby@telsasoft.com>
Re: explain analyze rows=%.0f Amit Kapila <amit.kapila16@gmail.com>
Re: explain analyze rows=%.0f Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Naeem Akhter <akhternaeem@gmail.com>
Re: explain analyze rows=%.0f Hamid Akhtar <hamid.akhtar@percona.com>
Re: explain analyze rows=%.0f Hamid Akhtar <hamid.akhtar@percona.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f "Gregory Stark (as CFM)" <stark.cfm@gmail.com>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Daniel Gustafsson <daniel@yesql.se>
Re: explain analyze rows=%.0f Daniel Gustafsson <daniel@yesql.se>
Re: explain analyze rows=%.0f Peter Geoghegan <pg@bowt.ie>
Re: explain analyze rows=%.0f Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
Re: explain analyze rows=%.0f Joshua Tolley <eggyknap@gmail.com>
Re: explain analyze rows=%.0f Tom Lane <tgl@sss.pgh.pa.us>
Re: explain analyze rows=%.0f Robert Haas <robertmhaas@gmail.com>
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 по дате отправления
