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