Postgres Pro
Downloads
Home   >   mailing lists

Re: can postgres btree indexes shrink? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: can postgres btree indexes shrink?
Date
Msg-id 20130626175516.GH5940@eldon.alvh.no-ip.org
Whole thread Raw
In response to can postgres btree indexes shrink?  (Azad Bolour <azadbolour@bolour.com>)
Responses Re: can postgres btree indexes shrink?  (Azad Bolour <azadbolour@bolour.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Azad Bolour
Date:
Subject: can postgres btree indexes shrink?
Next
From: Azad Bolour
Date:
Subject: Re: can postgres btree indexes shrink?