Skip site navigation (1) Skip section navigation (2)

Re: BUG #6187: Select query stuck

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Bhavesh Dangi <dangi(dot)bhavesh86(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6187: Select query stuck
Date: 2011-08-30 18:33:17
Message-ID: 4E5D2CED.3030803@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 30.08.2011 14:28, Bhavesh Dangi wrote:
> PostgreSQL version: PostgreSQL8.0.1

That version is over 6 years old. PostgreSQL 8.0 major version is no 
longer supported, see 
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy. Even 
if it was, the latest (and last) minor release from the 8.0 series was 
8.0.26, and there was a lot of important bug-fixes between 8.0.1 and that.

> 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.

That's unlikely a bug. See 
http://wiki.postgresql.org/wiki/SlowQueryQuestions. But upgrading is the 
first thing you need to do.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2011-08-30 18:35:32
Subject: Re: BUG #6186: out of memory while analyze
Previous:From: Alvaro HerreraDate: 2011-08-30 18:22:56
Subject: Re: BUG #6185: Segmentation fault with NULL string columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group