Postgres Pro
Downloads
Home   >   mailing lists

Re: REINDEX takes half a day (and still not complete!) - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: REINDEX takes half a day (and still not complete!)
Date
Msg-id C43BAB96-EA42-46DA-A456-B00AB8E65BA5@krogh.cc
Whole thread Raw
In response to Re: REINDEX takes half a day (and still not complete!)  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-performance
Tree view


How do DB folks do this with small maintenance windows? This is for a
very high traffic website so it's beginning to get embarrassing.

Normally there is no need to issue reindex.  What's your reason for the need?

Jesper


pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: REINDEX takes half a day (and still not complete!)
Next
From: Scott Marlowe
Date:
Subject: Re: REINDEX takes half a day (and still not complete!)