Home > mailing lists

Re: toast tables - Mailing list pgsql-admin

From	Scott Mead
Subject	Re: toast tables
Date	May 10, 2016 03:17:15
Msg-id	E70D1129-6ED8-4459-881C-BE94AC8318A6@openscg.com Whole thread Raw
In response to	Re: toast tables ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
List	pgsql-admin

Tree view

On May 9, 2016, at 18:16, "drum.lucas@gmail.com" <drum.lucas@gmail.com> wrote:

Have you tried to estimate bloat?

(from https://github.com/ioguix/pgsql-bloat-estimation/tree/master/table)

Yep...

bloat_ratio for tables in that schema: 14.066081480186922

but, to run the pg_repack I would have to have free disk space, right?

Yes.

Scott Mead via mobile

Skype : scottm.openscg

Gtalk : scottm@openscg.com

pgsql-admin by date:

From: "drum.lucas@gmail.com"
Date: 10 May 2016, 02:16:53
Subject: Re: toast tables

From: Bob Lunney
Date: 10 May 2016, 04:21:38
Subject: Re: Autovacuum of pg_database

Re: toast tables - Mailing list pgsql-admin

Previous

Next