Best practice when reindexing in production - Mailing list pgsql-performance

From Niels Kristian Schjødt
Subject Best practice when reindexing in production
Date
Msg-id 5359686B-FAE8-4056-AF13-F9FD6919FE82@autouncle.com
Whole thread Raw
Responses Re: Best practice when reindexing in production
Re: Best practice when reindexing in production
Re: Best practice when reindexing in production
List pgsql-performance
Hi,

I have a database with quite some data (millions of rows), that is heavily updated all the time. Once a day I would
liketo reindex my database (and maybe re cluster it - don't know if that's worth it yet?). I need the database to be
usablewhile doing this (both read and write). I see that there is no way to REINDEX CONCURRENTLY - So what approach
wouldyou suggest that I take on this? 

Regards Niels Kristian

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Performance of complicated query
Next
From: Magnus Hagander
Date:
Subject: Re: Best practice when reindexing in production