BUG #14597: Delay in query execution

aravinth.s@vortexindia.co.in writes:

The following bug has been logged on the website:
Bug reference: 14597
Logged by: Aravinth Sundaram
Email address: aravinth.s@vortexindia.co.in
PostgreSQL version: Unsupported/Unknown
Operating system: Windows Server 2008
Description:

A simple delete query performed on a table with 3000 rows took almost 2 hrs
and 40 mins. The table was vacuumed before executing the query. SQL Server
was running in the same machine. What could be the reason for the delay?

This is (a) probably not a bug, and (b) entirely undiagnosable from
the amount of information you've given.

For help with asking answerable questions, see

https://wiki.postgresql.org/wiki/Slow_Query_Questions

(But, FWIW, a common reason for slow deletes is a foreign key
referencing this table, where the referencing column is unindexed.
Or maybe the delete was just blocked on somebody's exclusive lock?)

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs