Re: size of table + toasted tables + indexes != pg_total_relation_size

From: Rui DeSousa <rui(at)crazybean(dot)net>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: size of table + toasted tables + indexes != pg_total_relation_size
Date: 2018-11-04 19:49:57
Message-ID: 8EFF8B0B-6CDA-41A7-B059-AD2E5D7701CE@crazybean.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Nov 4, 2018, at 5:14 AM, Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> wrote:
>
> local dba used to run vacuum full on a daily basis

Shouldn’t be doing vacuum fulls; that’s just bad db management. Autovacuum/vacuum and normal turnover rate should be enough; otherwise you server is mostly not sized correctly.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-05 11:24:00 PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdown checkpoint
Previous Message Andrew Gierth 2018-11-04 16:47:06 Re: size of table + toasted tables + indexes != pg_total_relation_size