Re: delete to slow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Ricardo Valen?a de Assis <valenca(at)campusvirtual(dot)br>, Bruno Wolff III <bruno(at)wolff(dot)to>, pgsql-admin(at)postgresql(dot)org
Subject: Re: delete to slow
Date: 2005-04-06 18:15:39
Message-ID: 28823.1112811339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Jim C. Nasby" <decibel(at)decibel(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ricardo Valença de Assis 2005-04-06 18:23:57 Re: delete to slow
Previous Message Jim C. Nasby 2005-04-06 18:02:04 Re: delete to slow