Postgres Pro
Downloads
Home   >   mailing lists

Re: Table and Index bloating - Mailing list pgsql-general

From Stefan Fercot
Subject Re: Table and Index bloating
Date
Msg-id cf40507d-5386-7dc1-cb1a-9a1a4ffa9f83@dalibo.com
Whole thread Raw
In response to Table and Index bloating  (Vikas Sharma <shavikas@gmail.com>)
Responses Re: Table and Index bloating
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: Vikas Sharma
Date:
Subject: Table and Index bloating
Next
From: Jakub Glapa
Date:
Subject: ERROR: too many dynamic shared memory segments