Thank you Stefan for the queries. Thanks you Carlos for pg_repack suggestion, Can we use pg_repack with standard community edition of postgresql? and can it be used on the databases with streaming replication?
Regards Vikas Sharma On 27 November 2017 at 14:58, Carlos Martinez <cama...@gmail.com> wrote: > 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 > > > > > >
