From: | gleeco <gleeco(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | is replication effected by exclusive locks? |
Date: | 2017-03-25 19:02:26 |
Message-ID: | CADv14s8YNBvx5VnWzTOk27_q7YyRDtCcELoY4mUfb7EFpsYNMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
hello - first a thank-you to this list for all previous questions answered
here!
In our cluster, we're using read-only replicas for answering postgis geo
queries. Often, i see multiple queries coming in concurrently & regularly
taking 2-10 seconds. When looking closer at these queries, i see they all
use an ExclusiveLock.
And when this is the query traffic, there can be increasing replication lag.
But also - there can be waves of tx cancellation due to conflicts, ie.
replication.
note that in this setup, pg_vacuum_defer_cleanup_age = 0 so the cancels
make sense to me.
So the simple question: do ExclusiveLock compete or block application of
wal logs on read replicas?
thanks in advance for thoughts/tips/links/etc
From | Date | Subject | |
---|---|---|---|
Next Message | gleeco | 2017-03-25 19:11:11 | Re: is replication effected by exclusive locks? |
Previous Message | Steven Chang | 2017-03-25 05:01:35 | Re: The same role for multiple databases |