Postgres Pro
Downloads
Home   >   mailing lists

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

From Azad Bolour
Subject Re: can postgres btree indexes shrink?
Date
Msg-id CAAp=Jg-PhZCp-t5yz3HPhw1PWKNOoRWeonKix7UEUUDpT5ZYeQ@mail.gmail.com
Whole thread Raw
In response to Re: can postgres btree indexes shrink?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-admin
Tree view

Thanks so much for the clarification.

Azad


On Wed, Jun 26, 2013 at 10:55 AM, Alvaro Herrera <alvherre@2ndquadrant.com> 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

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: can postgres btree indexes shrink?
Next
From: Sergey Konoplev
Date:
Subject: Re: pg_upgrade / postgis issue