From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bob Jolliffe <bobjolliffe@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: deadlock under load
In-reply-to: 
 <CACd=f9f23HcbR+iMfqBz32_iEamuaBX-hUgYBDVgHUZt1fWh2A@mail.gmail.com>
References: 
 <CACd=f9f23HcbR+iMfqBz32_iEamuaBX-hUgYBDVgHUZt1fWh2A@mail.gmail.com>
Comments: In-reply-to Bob Jolliffe <bobjolliffe@gmail.com>
	message dated "Fri, 30 Nov 2012 14:34:15 +0000"
Date: Fri, 30 Nov 2012 10:57:14 -0500
Message-ID: <13447.1354291034@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Bob Jolliffe <bobjolliffe@gmail.com> writes:
> We am running a web application on ubuntu 10.10 using postgres 8.4.3.

Current release in that branch is 8.4.14.  (By this time next week
it'll be 8.4.15.)  You are missing a lot of bug fixes:
http://www.postgresql.org/docs/8.4/static/release.html

> Trying to interpret this, does this mean that the autovacuum process is
> holding a lock which is required tn order to complete the select
> query?

Possibly.  Looking into the pg_locks view would tell you more.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance