From: | Scott Mead <scottm(at)openscg(dot)com> |
---|---|
To: | "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: toast tables |
Date: | 2016-05-10 00:17:09 |
Message-ID: | E70D1129-6ED8-4459-881C-BE94AC8318A6@openscg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On May 9, 2016, at 18:16, "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)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(at)openscg(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Lunney | 2016-05-10 01:21:31 | Re: Autovacuum of pg_database |
Previous Message | drum.lucas@gmail.com | 2016-05-09 23:16:09 | Re: toast tables |