From: | Bob Jolliffe <bobjolliffe(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: deadlock under load |
Date: | 2012-11-30 16:13:11 |
Message-ID: | CACd=f9e3D0-P9nhWOebfgU3DUAcB5gDhT-WFdiYzx27CAFYvfQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 30 November 2012 15:57, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bob Jolliffe <bobjolliffe(at)gmail(dot)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
>
>
Sorry I reported that incorrectly. 8.4.3 was initially installed but the
package system has kept it up to date. Currently it is in fact 8.4.14.
> > 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.
>
Ok. I guess I will have to wait for it to lock up again to do this.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Chobot | 2012-11-30 19:57:07 | shared_buffers on ubuntu precise |
Previous Message | Shaun Thomas | 2012-11-30 16:06:36 | Re: Optimize update query |