"=?ISO-8859-5?B?svbi0Nv22SDC2Nzn2OjY3Q==?=" <[EMAIL PROTECTED]> writes: > delete from company where id not in (select company_id from company_descr); > I've tried to analyze command, but unlike to other RDBM I've used it did not > include cascade deletes/checks into query plan. That is first problem. > It was SLOW.
Usually the reason for that is having forgotten to make an index on the referencing column(s) ? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance