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:
> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: Optimize update query
Следующее
От: Ben Chobot
Дата:
Сообщение: shared_buffers on ubuntu precise