Re: Table and Index bloating

Hi.

Can we use pg_repack with standard community edition of postgresql? Yes.
and can it be used on the databases with streaming replication? Yes.

Best regards.

Carlos Martinez

On Mon, Nov 27, 2017 at 10:08 AM, Vikas Sharma <shavikas(at)gmail(dot)com> wrote:
> 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
>> >
>> >
>>
>