From: | "Thomas Chille" <thomas(at)chille(dot)de> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: autovacuum process blocks without reporting a deadlock |
Date: | 2007-11-27 15:16:25 |
Message-ID: | cad2de1c0711270716q66c1ecc0vc48bed2d82e1539@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
yes, u are right.
this are the 3 involved indexes:
hst_timerecording_business_day_idx on hst_timerecording
hst_timerecording_id_employee_idxon hst_timerecording
hst_timerecording_id_timerecording_idxon hst_timerecording
lg t
On Nov 27, 2007 4:07 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> Alvaro Herrera wrote:
> > Thomas Chille wrote:
> > > On Nov 27, 2007 3:14 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
> > > hat are the column headings? I find this difficult to read.
> > > >
> > > > Please post the whole of pg_locks. I may be missing something but I
> > > > think we're missing part of the picture here. Autovacuum does not seem
> > > > to be locking on anything.
> > >
> > > Unfortunately i logged the pg_locks-state not well formated. i added
> > > now the heading manually. maybe it is better or i have to wait till
> > > tomorrow morning.
> > >
> > > but what i think i can see, is that the process with pid 9317 is
> > > holding a ShareUpdateExclusiveLock
> >
> > You missed that 9317 is also holding an ExclusiveLock.
>
> Sorry, I misread it. My analysis is bogus :-) I suggest you upgrade
> anyway because there are nasty bugs in the version you are using.
>
> I assume 77862554, 77862552 and 77862553 are indexes on the 75686189
> table?
>
> --
> Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
>
> "La experiencia nos dice que el hombre peló millones de veces las patatas,
> pero era forzoso admitir la posibilidad de que en un caso entre millones,
> las patatas pelarían al hombre" (Ijon Tichy)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-27 15:52:10 | Re: autovacuum process blocks without reporting a deadlock |
Previous Message | Scott Marlowe | 2007-11-27 15:09:15 | Re: Connection idle broken |