On Fri, Mar 2, 2012 at 6:22 AM, Gregg Jaskiewicz <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
