can postgres btree indexes shrink?

From: Azad Bolour <azadbolour(at)bolour(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: can postgres btree indexes shrink?
Date: 2013-06-26 16:22:31
Message-ID: CAAp=Jg9T_Ly+kL23PsdfzWp9LCJRLcS0o=w6G9zNu-D2rJA1Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Does the postgres implementation of btrees shrink the index if adjacent
index tree nodes can be combined?

I have read that data pages are not coalesced, only garbage collected when
they become empty. But I have not seen anything specific about the
treatment of index pages as deletions make the tree more sparse.

Thanks.

Azad

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2013-06-26 17:55:17 Re: can postgres btree indexes shrink?
Previous Message Bruce Momjian 2013-06-26 14:16:30 Re: pg_upgrade / postgis issue