Re: Too much time to delete 19000 rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Too much time to delete 19000 rows
Date: 2006-10-06 18:27:21
Message-ID: 4246.1160159241@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> writes:
> The selection takes less than 1 second but on delete I wait more than 4
> minutes and notthing. Can someone tell me what could happen ?

Perhaps foreign keys referencing this table and no indexes on the
referencing columns? You're not required to have an index on the
referencing side, but you pay for it when you update or delete in
the master table...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2006-10-06 18:27:26 Re: timestamps over the web - suggestions
Previous Message Andrew Sullivan 2006-10-06 18:26:54 Re: Too much time to delete 19000 rows