Re: long running transactions - Mailing list pgsql-performance

From Tobias Brox
Subject Re: long running transactions
Date
Msg-id 20061010170639.GB5360@oppetid.no
Whole thread Raw
In response to Re: long running transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: long running transactions
List pgsql-performance
[Tom Lane - Tue at 12:42:52PM -0400]
> > belonging to autovacuum ... how come?
>
> Blocked on someone else's lock, maybe?

hardly, the autovacuum is the only one having such a low transaction id,
and also the only one hanging around when waiting a bit and rechecking
the pg_locks table.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: long running transactions
Next
From: Tom Lane
Date:
Subject: Re: long running transactions