From: | Carlos Martinez <camarti(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table and Index bloating |
Date: | 2017-11-27 14:58:00 |
Message-ID: | CA+Mn-VZWjuxD6_=g=kfjK5mh1gd651+7ensULKVLHfKApE-THw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi.
You can consider use pg_repack to remove bloat
(http://reorg.github.io/pg_repack/)
Best regards.
Carlos Martinez
On Mon, Nov 27, 2017 at 4:17 AM, Stefan Fercot <stefan(dot)fercot(at)dalibo(dot)com> wrote:
> Hi,
>
> You can track that with some monitoring tools like check_pgactivity. The
> queries can be found here :
> https://github.com/ioguix/pgsql-bloat-estimation.
>
> Tables :
> https://github.com/ioguix/pgsql-bloat-estimation/blob/master/table/table_bloat.sql
> Indexes :
> https://github.com/ioguix/pgsql-bloat-estimation/blob/master/btree/btree_bloat.sql
>
> Backups should also be part of your maintenance plan.
> Vacuum/Analyse/Reindex is already a good basis.
>
>
> Kind regards
>
>
> On 11/27/2017 10:10 AM, Vikas Sharma wrote:
>> Hi All,
>>
>> Could someone please provide the query/queries to find table and
>> Index bloating in PgSql 9.3 onwards?
>> and are there any other maintenance tasks inPgSql except vacuum & analyse.
>>
>> Regards
>> Vikas
>
> --
> Stefan FERCOT
> http://dalibo.com - http://dalibo.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vikas Sharma | 2017-11-27 15:08:06 | Re: Table and Index bloating |
Previous Message | PeterS | 2017-11-27 13:06:33 | Install numpy to use within plpython3u in postgres 9.6 for Windows 2012 (64 bit) |