Re: [GENERAL] Locks Postgres

On 2/9/2017 9:00 PM, Patrick B wrote:
>
> Access share = Does that mean queries were waiting because an
> update/delete/insert was happening?
>

access share is taken by a SELECT, and all it blocks is an ACCESS
EXCLUSIVE lock, which is taken by operations like ALTER TABLE, VACUUM
FULL, and such global table operations.   that spike in your graph
suggests you had 8000 concurrent SELECT operations going on, which is
likely way more than you have compute and IO resources to handle
efficiently.


--
john r pierce, recycling bits in santa cruz