Re: deadlock under load
| От | Bob Jolliffe |
|---|---|
| Тема | Re: deadlock under load |
| Дата | |
| Msg-id | CACd=f9e3D0-P9nhWOebfgU3DUAcB5gDhT-WFdiYzx27CAFYvfQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: deadlock under load (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-performance |
On 30 November 2012 15:57, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Bob Jolliffe <bobjolliffe@gmail.com> writes:Current release in that branch is 8.4.14. (By this time next week
> We am running a web application on ubuntu 10.10 using postgres 8.4.3.
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 isPossibly. Looking into the pg_locks view would tell you more.
> holding a lock which is required tn order to complete the select
> query?
Ok. I guess I will have to wait for it to lock up again to do this.
regards, tom lane
В списке pgsql-performance по дате отправления: