Re: Removing width from EXPLAIN

Поиск
Список
Период
Сортировка
От greg@turnstep.com
Тема Re: Removing width from EXPLAIN
Дата
Msg-id f4d16ea6ce779b953ca25f080d903fa6@biglumber.com
обсуждение исходный текст
Ответ на Re: Removing width from EXPLAIN  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Removing width from EXPLAIN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I guess I was thinking about this:

http://groups.google.com/groups?selm=10897.953919427%40sss.pgh.pa.us

"Average width is pretty bogus because the thing really doesn't haveany idea of the average length of variable-length
columns. I'm thinkingabout improving that in the future, but it may not be worth the trouble,because the width isn't
usedfor very much."
 

I also think that it is used that much: if you look at all the EXPLAINS 
that have come across the various lists over the years, very few (if any) 
utilize the "width" in any important way. It's important for computing 
the cost, but I would like to suggest that the extra "noise" should be 
off by default as most people never make use of it, and an EXPLAIN ANALYZE 
is already quite verbose.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200305201143

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+ynErvJuQZxSWSsgRAsiKAKDXEaCPnhq8koIhnFNNPfm5HzhA9gCgszok
bBRBoL4Uoe8gqXzizeLlU2o=
=I1sV
-----END PGP SIGNATURE-----




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Suggestion GRANT ALTER, TRIGGER ON ALTER
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Suggestion GRANT ALTER, TRIGGER ON ALTER