Decibel! wrote:
I wrote this query to identify how much space is being wasted in a
database by denormalized data. For each field in each table, it
calculates how much space the field is taking in it's table as well
as indexes, then it calculates how much space would be needed if that
field was normalized into a separate table. It places some (somewhat
arbitrary) minimums on how much space would have to be saved to
include that field in the output. If you want to get rid of the limit
you should still keep savings > 0 in the query, otherwise you'll
start seeing normalization suggestions that make no sense (like
normalizing an int).
That's... really cool.
What does this mean? :)
pg_size_pretty
----------------
(1 row)
Colin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
