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>
>> "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.