Re: Slow deletes

Edmund Dengler <edmundd@eSentire.com> writes:
> Thanks! That seems to have been the issue!
> => explain delete from syslog_event where event_id = 1000::int8;
> NOTICE:  QUERY PLAN:

> Index Scan using syslog_event_event_id_idx on syslog_event
> (cost=0.00..3.02 rows=1 width=6)

That's better.

> Deleting a single row now takes only about 5 seconds.

Hm, still seems like a huge amount of time to delete a single row.
I suspect query-optimization problems inside your triggers.
Can't say much without more details though.

            regards, tom lane