On Fri, Jun 26, 2009 at 1:34 AM, Janet Jacobsen wrote:
> Thank you for the answers. Very helpful.
>
> Between the time that I sent my original post and saw your reply,
> I tried to drop a couple of foreign key constraints. The alter
> table statements also showed up as "waiting" when I ran ps aux
Hi. I posted a question about a very slow DELETE on a table
with 12 M rows last week, and I wanted to (1) thank everyone
who provided a reply since each clue helped to find the solution,
and (2) give the solution.
The slow DELETE was due to another user having a lock on
the table - which several
