Re: slow delete

From: PFC <lists(at)peufeu(dot)com>
To: "Jessica Richard" <rjessil(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow delete
Date: 2008-07-04 10:11:17
Message-ID: op.udrik3eocigqcu@apollo13.peufeu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> by the way, there is a foreign key on another table that references the
> primary key col0 on table test.

Is there an index on the referencing field in the other table ? Postgres
must find the rows referencing the deleted rows, so if you forget to index
the referencing column, this can take forever.

In response to

  • slow delete at 2008-07-04 00:44:40 from Jessica Richard

Browse pgsql-performance by date

  From Date Subject
Next Message Jessica Richard 2008-07-04 12:30:06 Re: slow delete
Previous Message Russell Smith 2008-07-04 05:30:50 Re: Define all IP's in the world in pg_hba.conf