Re: autovacuum process blocks without reporting a deadlock

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Thomas Chille <thomas(dot)chille(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: autovacuum process blocks without reporting a deadlock
Date: 2007-11-23 12:32:58
Message-ID: 20071123123258.GC4771@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Chille escribió:

> This are the last log entires for these both processes. Over 9 hours
> later, i can see them allready running in the process list :
>
> 14391 ? S 0:00 postgres: autovacuum process
> backoffice_db
> 14398 ? S 0:02 postgres: spoon backoffice_db office(39302)
> SELECT waiting

Can you paste the relevant lines from pg_locks?

--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Bishop 2007-11-23 12:41:53 Re: tsearch2 best practices
Previous Message Thomas Chille 2007-11-23 12:25:29 autovacuum process blocks without reporting a deadlock