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