| From: | Ezequiel Luis Pellettieri <ezequiel(dot)pellettieri(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Issue when crete or replace view |
| Date: | 2019-09-27 18:34:22 |
| Message-ID: | CAGsySmi51W-A2c9GZV+0DoQtaFMFkCe8w-z20Ago_3p=ZOSwtA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi guys, I'm having issues when I try to create or replace a view every
night. When I check the logs I can see that it was waiting for some PIDs
and all of them where SELECT jobs. I've been reading that create or replace
a view need exclusive lock, so I would have to wait until the SELCTs to
end. Is there a way to troubleshoot this? I was thinking of creating a RO
replica for those selects. What do you think?
Thanks!
Pelle.-
* <http://www.facebook.com/ezequiel.pellettieri>
<http://twitter.com/#!/epellettieri>
<http://www.linkedin.com/in/ezequielpellettieri>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naveen Sankineni | 2019-09-28 14:02:20 | Query Tuning |
| Previous Message | Ron | 2019-09-27 14:44:11 | Re: Files overwritten when installing v9.6 in machine with v8.4 previously running |