The following bug has been logged online:
Bug reference: 6187
Logged by: Bhavesh Dangi
Email address: dangi.bhavesh86@gmail.com
PostgreSQL version: PostgreSQL8.0.1
Operating system: i686-pc-linux-gnu
Description: Select query stuck
Details:
Hello,
Here the problem is SELECT query takes a lot of time(in days) to return a
result than expected time and sometimes it stop to responding. Its totally
hang. We are suffering from last 1 years by having this issue. If it will
happen then we finding that query from pg_stat_activity and cancel it but
that is not a solution of problem.
We also found that almost SELECT queries are stuck. We are also continuous
performing veccumdb before 2 billion transactions.
I hope that you will be provide some way to solve it.
Thanks & Regards,
Bhavesh Dangi