Re: [GENERAL] Locks Postgres - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] Locks Postgres
Date
Msg-id 824f4cc0-a3e8-cc14-650f-5899e19c71b3@aklaver.com
Whole thread Raw
In response to [GENERAL] Locks Postgres  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On 02/09/2017 09:00 PM, Patrick B wrote:
> Hi guys
>
> I just wanna understand the locks in a DB server:
> Imagem inline 1
>
> Access share = Does that mean queries were waiting because an
> update/delete/insert was happening?

https://www.postgresql.org/docs/9.3/static/explicit-locking.html

>
> I'm asking because I got a very big spike with > 30 seconds web response
> time.
> Running PG 9.3
>
> Thanks!
> Patrick


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: [GENERAL] Locks Postgres
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] Locks Postgres