On Tue, Jun 12, 2018 at 10:48 AM, Don Seiler <d...@seiler.us> wrote: > On Tue, Jun 12, 2018 at 2:26 AM, Haug Bürger <haug.buer...@zalando.de> > wrote: > >> >> "availability_cache_ac_session_id_fkey" FOREIGN KEY (ac_session_id) >> REFERENCES zpg_data.session(id) ON DELETE CASCADE >> >> > Do you have an index on availability_cache.ac_session_id? These fields > are not automatically indexed and that can lead to horrible performance on > cascading operations like this. >
I'm blind apparently, it's your PK. -- Don Seiler www.seiler.us
