Postgres Pro
Downloads
Home   >   mailing lists

Re: size of table + toasted tables + indexes !=pg_total_relation_size - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: size of table + toasted tables + indexes !=pg_total_relation_size
Date
Msg-id 8EFF8B0B-6CDA-41A7-B059-AD2E5D7701CE@crazybean.net
Whole thread Raw
In response to size of table + toasted tables + indexes != pg_total_relation_size  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Tree view 

> On Nov 4, 2018, at 5:14 AM, Mariel Cherkassky <mariel.cherkassky@gmail.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.

pgsql-admin by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: size of table + toasted tables + indexes != pg_total_relation_size
Next
From: Achilleas Mantzios
Date:
Subject: PostgreSQL 10.5 : Strange pg_wal fill-up, solved with the shutdowncheckpoint