Re: Bloat and Slow Vacuum Time on Toast

On Tue, Jul 19, 2011 at 2:26 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Ken Caruso <ken(at)ipl31(dot)net> writes:
> > I am trying to trouble shoot a couple of issue related to vacuum and db
> > size. I currently have a postgres DB that is around 390GB on disk (du -hs
> in
> > $PG_DATA/base). If I look at the total relation size using the following
> > query:
>
> > SELECT SUM(pg_relation_size(pg_class.oid))
> > FROM pg_class ;
>
> > This says the total size is around 191GB. That query should sum all of
> the
> > tables, toast and indexes AFAIK.
>
> What PG version?
>

9.0.4

-Ken

>
> If it's a version with multiple table forks, you're only counting the
> main forks, not FSM or VM.
>
> Theoretically the latter two should be pretty small relative to the main
> fork, but obviously you are missing something with this query ...

> regards, tom lane
>