CS DBA <cs_dba(at)consistentstate(dot)com> writes:
> I have several prepared tx which are running for a long long time. I
> want to kill 'em but I dont know the process id.
If they're prepared, they're *not* running, and they don't have a
process id. They're just going to sit there until you do COMMIT
PREPARED or ROLLBACK PREPARED.
regards, tom lane