Re: can postgres btree indexes shrink?

From: Azad Bolour <azadbolour(at)bolour(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: can postgres btree indexes shrink?
Date: 2013-06-26 18:15:35
Message-ID: CAAp=Jg-PhZCp-t5yz3HPhw1PWKNOoRWeonKix7UEUUDpT5ZYeQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks so much for the clarification.

Azad

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sergey Konoplev 2013-06-26 19:09:03 Re: pg_upgrade / postgis issue
Previous Message Alvaro Herrera 2013-06-26 17:55:17 Re: can postgres btree indexes shrink?