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

Re: Vacuum blocking...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum blocking...
Date: 2002-04-16 13:31:52
Message-ID: 11603.1018963912@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Jean-Arthur Silve <jeanarthur(at)eurovox(dot)fr> writes:
> Now, vacuum "blocks" on one table (apparently "comptes" table) , without HD 
> activity, no error message....

Curious.  Do you want to get in there with a debugger and see where it's
looping?

> PS : I use 7.0 version

Hmm ... are you on 7.0.3?  There's a known bug in earlier releases that
could perhaps lead to an endless loop in VACUUM.

The simplest answer is probably "past time to update to 7.2.1", anyway.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Edipo Elder Fernandes de MeloDate: 2002-04-16 13:52:15
Subject: Re: psql command line history not working
Previous:From: Benjamin LaraDate: 2002-04-16 10:54:05
Subject: Postgresql on win2000

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