Re: Too much time to delete 19000 rows - Mailing list pgsql-sql

From Tom Lane
Subject Re: Too much time to delete 19000 rows
Date
Msg-id 4246.1160159241@sss.pgh.pa.us
Whole thread Raw
In response to Too much time to delete 19000 rows  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
"Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.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


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Too much time to delete 19000 rows
Next
From: Kyle Bateman
Date:
Subject: PG 8.2beta reordering working for this case?