On 12 Oct 2014, at 18:41, Arun Gokule wrote:
> Hi,
>
> I am executing pg_advisory_locks using the following set of statements:
>
> SELECT pg_advisory_lock(317,2);
> UPDATE posts SET dislikers = array_remove(dislikers, 7) WHERE id = 317;
> update posts set num_dislikes = icount(dislikers), u
Also I noticed that executing the following query:
SELECT *
FROM
(
SELECT DISTINCT age(now(), query_start) AS age,
pg_stat_activity.pid,pg_locks.granted,pg_stat_activity.application_name,pg_stat_activity.backend_start,
pg_stat_activity.xact_start, pg_stat_activity.state_change,
pg_stat_activ
Hi,
I am executing pg_advisory_locks using the following set of statements:
SELECT pg_advisory_lock(317,2);
UPDATE posts SET dislikers = array_remove(dislikers, 7) WHERE id = 317;
update posts set num_dislikes = icount(dislikers), updated_at = now()
where id = 317;
WITH update_likers AS (SELE
