Thread: [BUGS] BUG #14597: Delay in query execution

[BUGS] BUG #14597: Delay in query execution

From
aravinth.s@vortexindia.co.in
Date:
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?


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

Re: [BUGS] BUG #14597: Delay in query execution

From
Tom Lane
Date:
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