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
n/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
.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:
lso 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
-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 an
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
