Issue when crete or replace view - Mailing list pgsql-admin

From Ezequiel Luis Pellettieri
Subject Issue when crete or replace view
Date
Msg-id CAGsySmi51W-A2c9GZV+0DoQtaFMFkCe8w-z20Ago_3p=ZOSwtA@mail.gmail.com
Whole thread Raw
List 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.-


  

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Files overwritten when installing v9.6 in machine with v8.4previously running
Next
From: Naveen Sankineni
Date:
Subject: Query Tuning