Greetings,
I need help in optimizing this query:
select a.id, b.transaction from test as a left join pg_locks as b on
a.xmax = b.transaction where b.transaction is null;
im using the query in obtaining records not locked by other
transactions. any help is appreciated.
cheers!
Dexter Tad-y
