Re: [GENERAL] Request to share approach during REINDEX operation - Mailing list pgsql-general

From Vick Khera
Subject Re: [GENERAL] Request to share approach during REINDEX operation
Date
Msg-id CALd+dcf1oPCxb73MaCK7kWfEJpO0rwi1HbnLggpp_fcLFGbKrQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Request to share approach during REINDEX operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
List pgsql-general

On Wed, Dec 21, 2016 at 8:43 AM, Yogesh Sharma <yogeshraj95@gmail.com> wrote:
I have responded on previously mail.


apparently you started two separate threads...
 
In my production system, there are lot of read write operation performed every hour.

That still doesn't answer why you feel you need to run reindex every hour. Do you have some measurements that show the index is bloating, or not performing well?

I have a database that does hundreds of millions of insert/update per day, and I *never* run reindex because it is unnecessary.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: [GENERAL] How well does PostgreSQL 9.6.1 support unicode?
Next
From: Steven Winfield
Date:
Subject: Re: [GENERAL] Request to share approach during REINDEX operation