The attached patch will release prepared statements in GC even though they are
not finished explicitly.
  sth = dbh.prepare('select * from names')
  sth.execute
    ...
  sth = nil # forget to finish the statement handle.
  GC.start # <= sth's prepared statement is deallocated by GC.

Sorry, I have not test it. I have no working postgresql database...