Re: Dropping a temporary view?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Dropping a temporary view?
Дата
Msg-id CAKFQuwbJS1uE8F8ykXxuw6V6zQ7uB=y0US18bVCBwG2xp5wm+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dropping a temporary view?  (Celia McInnis <celia.mcinnis@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Celia McInnis
Дата:
Сообщение: Re: Dropping a temporary view?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Dropping a temporary view?