On 4/21/20 7:43 PM, Virendra Kumar wrote:
> Hi Adrian,
>
> Here is test case, basically when autovacuum runs it did release the
> space to disk since it had may be continuous blocks which can be
> released to disk but the space used by index is still being held until I
> ran the reindex on the table (I assume reindex for index would work as
> well). Subsequent insert statement did not utilize the blocks in index
> segment as we can see below so index bloats are still not addressed or
> may be I am doing something wrong:
>
Well I learned something. I replicated your commands on my 12 instance
and got the exact same results. I should have read this:
https://www.postgresql.org/docs/12/routine-reindex.html
before.
--
Adrian Klaver
adrian.klaver@aklaver.com