Re: can postgres btree indexes shrink?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Azad Bolour <azadbolour(at)bolour(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: can postgres btree indexes shrink?
Date: 2013-06-26 17:55:17
Message-ID: 20130626175516.GH5940@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Azad Bolour 2013-06-26 18:15:35 Re: can postgres btree indexes shrink?
Previous Message Azad Bolour 2013-06-26 16:22:31 can postgres btree indexes shrink?