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>*