Re: Table and Index bloating

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 <camarti(at)gmail(dot)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(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
> >
> >
>
>