On Thu, Mar 21, 2019 at 03:31:42PM -0400, Gunther wrote:
> Hi,
>
> I have 250 rows to delete, but they are a target to a bunch of child tables
> with foreign key on delete cascade.
>
> EXPLAIN DELETE FROM Foo WHERE id = (SELECT fooId FROM Garbage);
Probably because:
On 3/21/2019 17:16, Tom Lane wrote:
Gunther writes:
I have 250 rows to delete, but they are a target to a bunch of child
tables with foreign key on delete cascade.
EXPLAIN DELETE FROM Foo WHERE id = (SELECT fooId FROM Garbage);
shows me that it uses the nested loop by Foo_pkey index to find
On Fri, 22 Mar 2019 at 07:57, Gunther wrote:
> foo=# PREPARE testplan(int) AS
> foo-#SELECT * FROM Test WHERE mod(id,2) = mod($1,2) AND id = $1;
> PREPARE
> foo=# EXPLAIN EXECUTE testplan(8934);
> QUERY PLAN
>