Re: autovacuum process blocks without reporting a deadlock

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 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-24 05:20:04
Message-ID: 29175.1195881604@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thomas Chille" <thomas(dot)chille(at)gmail(dot)com> writes:
> One Autovacuum process stuck in the middle of the night and it seemed
> that it compete with another Select process for an index:

> [14391 / 2007-11-21 00:52:14 CET]DEBUG: 00000: index
> "hst_timerecording_id_timerecording_idx" now contains 8537 row
> versions in 61 pages

What other indexes does that table have?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-11-24 10:44:41 Re: manipulating HeapTuples in a libpq client
Previous Message Eric Davies 2007-11-24 00:51:53 manipulating HeapTuples in a libpq client