Re: autovacuum process blocks without reporting a deadlock - Mailing list 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@alvh.no-ip.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)
>