1 files changed, 14 insertions, 0 deletions
diff --git a/Locking.md b/Locking.md
new file mode 100644
index 0000000..aea1d62
--- /dev/null
+++ b/Locking.md
@@ -0,0 +1,14 @@
+Test data:
+
+    begin;
+    drop table x;
+    create table x(id integer not null primary key, value integer default random() * 1000);
+    insert into x(id) select * from generate_series(1, 100);
+    commit;
+
+Execution:
+
+    rollback;
+    begin;
+    select id from (select id from x order by value limit 10) as rows where pg_try_advisory_xact_lock(id);
+