From: | "Thomas Chille" <thomas(at)chille(dot)de> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: autovacuum process blocks without reporting a deadlock |
Date: | 2007-11-23 12:43:36 |
Message-ID: | cad2de1c0711230443h10ccab95y128525d5dd9f19af@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
i have to wait till monday, then i can provide these lines.
thanks,
thomas
On Nov 23, 2007 1:32 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> 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)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Bishop | 2007-11-23 12:47:17 | Re: plpython array support |
Previous Message | Stuart Bishop | 2007-11-23 12:41:53 | Re: tsearch2 best practices |