Home > mailing lists

[GENERAL] Locks Postgres - Mailing list pgsql-general

From	Patrick B
Subject	[GENERAL] Locks Postgres
Date	February 10, 2017 11:00:07
Msg-id	CAJNY3ivRCRcvArv6tDbnmJWhWzs+RgVGg78cN8c0cJO4tqp+YQ@mail.gmail.com Whole thread Raw
Responses	Re: [GENERAL] Locks Postgres (Adrian Klaver <adrian.klaver@aklaver.com>) Re: [GENERAL] Locks Postgres (John R Pierce <pierce@hogranch.com>) Re: [GENERAL] Locks Postgres (Jeff Janes <jeff.janes@gmail.com>)
List	pgsql-general

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?

I'm asking because I got a very big spike with > 30 seconds web response time.

Running PG 9.3

Thanks!

Patrick

Attachment

Screen Shot 2017-02-10 at 5.58.37 PM.png

pgsql-general by date:

Previous

From: Venkata B Nagothi
Date: 10 February 2017, 09:31:24
Subject: Re: [GENERAL] clarification about standby promotion

Next

From: Adrian Klaver
Date: 10 February 2017, 11:06:05
Subject: Re: [GENERAL] Locks Postgres