Adrian Klaver <adrian.klaver@aklaver.com> writes:
> SET enable_indexscan=off;
> EXPLAIN ANALYZE DELETE query
> SET enable_indexscan=on;
Note that you'd probably best do this in a fresh session, since the
supposed problem is being tickled by a foreign-key check. I think
the plans for those get cached, so if you'd already tried the same
case earlier in the session, changing enable_indexscan wouldn't
change the plan used.
regards, tom lane
