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?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company