After reading the web pages, index part should be succeeded, but tables may not
fit if they got foreign key relations.
steven
原始訊息 自： Carlos Martinez 日期： 2017/11/27
23:13 (GMT+08:00) 至： pgsql-gene...@postgresql.org 主旨： Re: Table and Index
bloating
Hi.
Can we use
-gene...@postgresql.org 主旨： Re: Table and Index bloating
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
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 wrote:
> Thank you Stefan for the queries.
>
> Thanks you Carlos for
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 wrote:
> Hi.
>
>
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 wrote:
> Hi,
>
> You can track that with some monitoring tools like check_pgactivity. The
> queries can be found here :
> https:/
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-es
