On 2 Mar 2012, at 15:28, Robert Haas wrote:
> On Fri, Mar 2, 2012 at 6:22 AM, Gregg Jaskiewicz <gryzman(at)gmail(dot)com> wrote:
>> Looking at the system bit more now, it look like 'waiting' states are
>> changing for both the query and autovacuum in pg_stat_activity.
>> But very slowly. It looks like they both got into that sort of state
>> that keeps them on the edge of starvation.
>>
>> So this isn't really a deadlock, but rather very poor performance in
>> this corner case.
>
> Are you making any use of cursors?
nope.