| 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: | Whole Thread | Raw Message | 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: |