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