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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
