Re: How to fast the REINDEX - Mailing list pgsql-performance

From Pierre C
Subject Re: How to fast the REINDEX
Date
Msg-id op.vahgtfv7eorkce@immo.peufeu.com
Whole thread Raw
In response to Re: How to fast the REINDEX  (Steve Clark <sclark@netwolves.com>)
Responses Re: How to fast the REINDEX
List 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 ;)



pgsql-performance by date:

Previous
From: Faheem Mitha
Date:
Subject: Re: experiments in query optimization
Next
From: raghavendra t
Date:
Subject: Re: How to fast the REINDEX