From: | Yogesh Sharma <yogeshraj95(at)gmail(dot)com> |
---|---|
To: | Alban Hertroys <haramrae(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2016-12-21 11:51:41 |
Message-ID: | CAEZUwCQ03FgLNA__YHs+EKnUvMhQC76MGvE79o9j-eMgZLHTBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Alban,
In my production system, there are lot of read write operation performed
every hour.
So, i am thinking, if i can add check during REINDEX operation nothing
update and insert operation performed.
Is it possible?
Regards,
Yogesh
On Wednesday, December 21, 2016, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:
> On 21 December 2016 at 09:59, Yogesh Sharma <yogeshraj95(at)gmail(dot)com
> <javascript:;>> wrote:
> > Also, every hour,i am performing VACUUM and REINDEX operation on table.
>
> Why are you running REINDEX every hour? That's a very unusual thing to
> do, you'd need a pretty good reason for that.
>
> --
> If you can't see the forest for the trees,
> Cut the trees and you'll see there is no forest.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Soler | 2016-12-21 12:12:35 | Re: |
Previous Message | Alban Hertroys | 2016-12-21 11:34:09 | Re: |