Postgres Pro
Downloads
Home   >   mailing lists

Re: random huge delay when recreate a VIEW or FUNCTION - Mailing list pgsql-general

From Merlin Moncure
Subject Re: random huge delay when recreate a VIEW or FUNCTION
Date
Msg-id CAHyXU0zm5N6WjnPuxc=zx6ihDfkZai3BMS2WiR1+ituV=m8gFg@mail.gmail.com
Whole thread Raw
In response to random huge delay when recreate a VIEW or FUNCTION  (Catalin Maftei <catalin@plationline.eu>)
List pgsql-general
Tree view 
On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei <catalin@plationline.eu> wrote:
> when I recreate a VIEW or FUNCTION with a small change I get:
>
> Query returned successfully with no result in 03:58 minutes.

This is almost certainly due to locks.  Next time this happens, query
pg_stat_activity and pg_locks -- the information is there to determine
if you are locked and who the locker is.  Your view creating query
would be blocked as 'waiting' if that's the case.

merlin

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: Hot disable WAL archiving
Next
From: Vick Khera
Date:
Subject: Re: Table ordering in pg_dump