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

From Ian Lawrence Barwick
Subject Re: Difference in the size of database size and relations
Date
Msg-id CAB8KJ=itrdPzQ-1iK40Vcbg-7bk5f7cmvKK9+=4+wTLDA2EF5g@mail.gmail.com
Whole thread Raw
In response to Difference in the size of database size and relations  (Luis <luisico@gmail.com>)
Responses Re: Difference in the size of database size and relations  (Luis <luisico@gmail.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Luis
Date:
Subject: Re: Difference in the size of database size and relations
Next
From: Luis
Date:
Subject: Re: Difference in the size of database size and relations