Re: can postgres btree indexes shrink?

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