Re: Dropping a temporary view? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Dropping a temporary view?
Date
Msg-id CAKFQuwbJS1uE8F8ykXxuw6V6zQ7uB=y0US18bVCBwG2xp5wm+w@mail.gmail.com
Whole thread Raw
In response to Re: Dropping a temporary view?  (Celia McInnis <celia.mcinnis@gmail.com>)
List pgsql-general
Top-posting is frowned upon on these lists.  Please try to reply online or at worse after the comments you are referencing.

On Wed, Mar 20, 2024, 10:54 Celia McInnis <celia.mcinnis@gmail.com> wrote:


No, unfortunately I didn't do an explain on the slow query - and it's too late now since the views are removed. However, I never had a delay when waiting for the view to be created in my web software, so, I'll just proceed being more careful and hope that the delay seen was due to some big mess I created.

If it isn't reproducible it is hard to diagnose. Given the time difference if it isn't fundamentally a different view then I'd be inclined to suspect locking issues as a probable factor.

David J.

pgsql-general by date:

Previous
From: Celia McInnis
Date:
Subject: Re: Dropping a temporary view?
Next
From: Adrian Klaver
Date:
Subject: Re: Dropping a temporary view?