"K. Ari Krupnikov" <ari@iln.net> writes:
> Many queries can be formulated as either a self-join or a subquery on
> the same table.
> Is there any difference in performance, or does the analyzer treat them
> the same?
You're a lot better off with a self-join, at present.
regards, tom lane