Massalin Yerzhan <yerzhik@xxxxxxxxx> writes: > I'm having an issue. The query never ends: > delete from bb_gamelist_league; 9 times out of 10, the answer to this type of problem is that you have some table referencing this one by a foreign key, and the referencing column is not indexed. PG doesn't require such an index, but lack of one will mean that retail checks or deletions of referencing rows are really slow. If you're not sure which table is the problem, try doing an EXPLAIN ANALYZE of a DELETE that will only remove a few rows. You should see some time blamed on a trigger associated with the FK constraint. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
