Re: can postgres btree indexes shrink?

[Azad Bolour <azadbolour@xxxxxxxxxx>]

Thanks so much for the clarification.

Azad

On Wed, Jun 26, 2013 at 10:55 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote:

Azad Bolour wrote:
> Does the postgres implementation of btrees shrink the index if adjacent
> index tree nodes can be combined?

No.  Completely empty pages are collected as free space for later use,
but partially-empty pages are not merged.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services