| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Erik Wienhold <ewie(at)ewie(dot)name>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Dropping a temporary view? |
| Date: | 2024-03-20 18:14:19 |
| Message-ID: | CAKFQuwbJS1uE8F8ykXxuw6V6zQ7uB=y0US18bVCBwG2xp5wm+w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)mcinnis(at)gmail(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2024-03-20 18:15:22 | Re: Dropping a temporary view? |
| Previous Message | Celia McInnis | 2024-03-20 17:54:25 | Re: Dropping a temporary view? |