Re: Difference in the size of database size and relations

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: Luis <luisico(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Difference in the size of database size and relations
Date: 2013-12-10 14:09:54
Message-ID: CAB8KJ=itrdPzQ-1iK40Vcbg-7bk5f7cmvKK9+=4+wTLDA2EF5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

2013/12/10 Luis <luisico(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Luis 2013-12-10 14:29:36 Re: Difference in the size of database size and relations
Previous Message Luis 2013-12-10 14:09:42 Re: Difference in the size of database size and relations