Re: Difference in the size of database size and relations - Mailing list pgsql-admin

Good one.

Unfortunately it doesn't show anything weird either.
Using any of these two scripts:
http://wiki.postgresql.org/wiki/Show_database_bloat
http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html

I can only see about 90MB

Thanks

2013/12/10 Ian Lawrence Barwick <barwick@gmail.com>:
> 2013/12/10 Luis <luisico@gmail.com>:
>> Thanks Ian,
>>
>> Actually the query I used to get the relations sizes also included
>> indexes and even pg_toast.
>
> Doh, sorry I didn't notice there was no relkind qualification on pg_class
> in your query.
>
>> This query gives me more detail about the
>> indexes related to every table but still can't see where the space is.
>
> Table/index bloat?
>
>
> Ian Barwick