Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporarily very slow planning time after a big delete - Mailing list pgsql-performance

From Peter Geoghegan
Subject Re: Temporarily very slow planning time after a big delete
Date
Msg-id CAH2-WzkdMf=6P0Dd9rN5dz_JFgjWE0DRCJLQkzoYw=Gw76Jx6Q@mail.gmail.com
Whole thread Raw
In response to Re: Temporarily very slow planning time after a big delete  (Walter Smith <walter@carezone.com>)
Responses Re: Temporarily very slow planning time after a big delete
List pgsql-performance
Tree view 
On Tue, May 21, 2019 at 11:12 AM Walter Smith <walter@carezone.com> wrote
> I did a VACUUM overnight and got the following. The thing that stands out to me is that one index
(index_unproc_notifications_on_notifiable_type)took 100x longer to scan than the others. That's not the index used in
theslow query, though.
 

What columns are indexed by
index_unproc_notifications_on_notifiable_type, and what are their
datatypes?

-- 
Peter Geoghegan

pgsql-performance by date:

Previous
From: Walter Smith
Date:
Subject: Re: Temporarily very slow planning time after a big delete
Next
From: Walter Smith
Date:
Subject: Re: Temporarily very slow planning time after a big delete