Re: Space wasted by denormalized data

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