"Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings