Re: Locks Postgres

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Locks Postgres
Date: 2017-02-10 05:06:05
Message-ID: 824f4cc0-a3e8-cc14-650f-5899e19c71b3@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2017-02-10 05:16:55 Re: Locks Postgres
Previous Message Patrick B 2017-02-10 05:00:07 Locks Postgres