From: | greg(at)turnstep(dot)com |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Removing width from EXPLAIN |
Date: | 2003-05-20 18:19:53 |
Message-ID: | f4d16ea6ce779b953ca25f080d903fa6@biglumber.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 have
any idea of the average length of variable-length columns. I'm thinking
about improving that in the future, but it may not be worth the trouble,
because the width isn't used for 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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200305201143
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQE+ynErvJuQZxSWSsgRAsiKAKDXEaCPnhq8koIhnFNNPfm5HzhA9gCgszok
bBRBoL4Uoe8gqXzizeLlU2o=
=I1sV
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-20 18:28:42 | Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON ALTER) |
Previous Message | Josh Berkus | 2003-05-20 18:19:36 | Re: Suggestion GRANT ALTER, TRIGGER ON ALTER |