Postgres Pro
Downloads
Home   >   mailing lists

Re: delete to slow - Mailing list pgsql-admin

From Tom Lane
Subject Re: delete to slow
Date
Msg-id 28823.1112811339@sss.pgh.pa.us
Whole thread Raw
In response to Re: delete to slow  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: delete to slow  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-admin
Tree view 
"Jim C. Nasby" <decibel@decibel.org> writes:
> Well, neither of those should take very long at all. What's EXPLAIN
> ANALYZE show?

Indeed ... now I'm wondering about foreign key checks.  Are there any
tables with foreign keys linking to usuario?  If so, the problem is
likely unindexed foreign key columns, or maybe a datatype mismatch
between foreign key and referenced column.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: delete to slow
Next
From: Ricardo Valença de Assis
Date:
Subject: Re: delete to slow