| 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: | Whole Thread | Raw Message | 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 |