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.fer...@dalibo.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 > >
