Search Postgresql Archives

Re: autovacuum process blocks without reporting a deadlock

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux