Edmund Dengler <edmundd(at)eSentire(dot)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