Re: Query to monitor index bloat

From: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
To: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>
Cc: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Query to monitor index bloat
Date: 2018-07-16 22:16:13
Message-ID: 6fc52c1d-53f7-89cf-985b-f4b743870bf5@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/16/2018 11:50 PM, Alessandro Aste wrote:
> Thanks much, I'll check that out.  I see the queries are 3 years old so I'm
> wondering if they still work for 9.6.x or 10

AFAIK they work. You can try yourself by comparing bloated table/index size
before and after vacuum full or reindex ;)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-07-16 22:18:43 Re: User documentation vs Official Docs
Previous Message David G. Johnston 2018-07-16 22:14:24 Re: User documentation vs Official Docs