Re: [GENERAL] Locks Postgres

Поиск

Список

Период

Сортировка

От	Jeff Janes
Тема	Re: [GENERAL] Locks Postgres
Дата	10 февраля 2017 г. 23:01:21
Msg-id	CAMkU=1z8GyZJiRCuYaBqC8HVqK10HV88D-SU+S8OHb8N0h6oHg@mail.gmail.com обсуждение исходный текст
Ответ на	[GENERAL] Locks Postgres (Patrick B <patrickbakerbr@gmail.com>)
Список	pgsql-general

Дерево обсуждения

On Thu, Feb 9, 2017 at 9:00 PM, Patrick B <patrickbakerbr@gmail.com> wrote:

Hi guys

I just wanna understand the locks in a DB server:

Access share = Does that mean queries were waiting because an update/delete/insert was happening?

It would seem more plausible that your chart is showing the locks that are *held*, not the locks that are *waiting to be granted*. But without knowing where the chart came from, we can't know for sure.

If those are locks being held, it just means your server was kind of busy (which you already knew). But we don't know how busy. A single complex query can easily hold several dozens locks.

Cheers,

Jeff