Issue when crete or replace view
Ezequiel Luis Pellettieri <[email protected]> Fri, 27 Sep 2019 15:34:22 -0300
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAGsySmi51W-A2c9GZV+0DoQtaFMFkCe8w-z20Ago_3p=ZOSwtA@mail.gmail.com> |
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>*