Search Postgresql Archives

Locks Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Locks Postgres
From: Patrick B <patrickbakerbr@xxxxxxxxx>
Date: Fri, 10 Feb 2017 18:00:07 +1300

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Locks Postgres
  - From: Jeff Janes
- Re: Locks Postgres
  - From: John R Pierce
- Re: Locks Postgres
  - From: Adrian Klaver

Prev by Date: Re: clarification about standby promotion
Next by Date: Re: Locks Postgres
Previous by thread: CREATE TABLE with parallel workers, 10.0?
Next by thread: Re: Locks Postgres
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux