[NEWBIE] need help optimizing this query

From: Dexter Tad-y <dexterbt1(at)my(dot)smart(dot)com(dot)ph>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: [NEWBIE] need help optimizing this query
Date: 2004-03-10 12:58:01
Message-ID: 1078923481.2833.45.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sferriol 2004-03-10 13:15:10 bug in rule?
Previous Message Peter Schuller 2004-03-10 12:28:40 Re: Sudden semi-deterministic disconnection between queries