Re: [GENERAL] Request to share approach during REINDEX operation

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: [GENERAL] Request to share approach during REINDEX operation
Дата
Msg-id CALd+dcf1oPCxb73MaCK7kWfEJpO0rwi1HbnLggpp_fcLFGbKrQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Request to share approach during REINDEX operation  (Yogesh Sharma <yogeshraj95@gmail.com>)
Список 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 по дате отправления: