On Tue, Jun 12, 2018 at 10:48 AM, Don Seiler <don(at)seiler(dot)us> wrote:
> On Tue, Jun 12, 2018 at 2:26 AM, Haug Bürger <haug(dot)buerger(at)zalando(dot)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