Re: How to fast the REINDEX

From: "Pierre C" <lists(at)peufeu(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to fast the REINDEX
Date: 2010-04-01 12:25:53
Message-ID: op.vahgtfv7eorkce@immo.peufeu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> So am I to understand I don't need to do daily reindexing as a
> maintenance measure with 8.3.7 on FreeBSD.

Sometimes it's better to have indexes with some space in them so every
insert doesn't hit a full index page and triggers a page split to make
some space.
Of course if the index is 90% holes you got a problem ;)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message raghavendra t 2010-04-01 13:47:15 Re: How to fast the REINDEX
Previous Message Faheem Mitha 2010-04-01 11:46:40 Re: experiments in query optimization