pgsql: Use ResourceOwner to track WaitEventSets.

Use ResourceOwner to track WaitEventSets.

A WaitEventSet holds file descriptors or event handles (on Windows).
If FreeWaitEventSet is not called, those fds or handles are leaked.
Use ResourceOwners to track WaitEventSets, to clean those up
automatically on error.

This was a live bug in async Append nodes, if a FDW's
ForeignAsyncRequest function failed. (In back branches, I will apply a
more localized fix for that based on PG_TRY-PG_FINALLY.)

The added test doesn't check for leaking resources, so it passed even
before this commit. But at least it covers the code path.

In the passing, fix misleading comment on what the 'nevents' argument
to WaitEventSetWait means.

Report by Alexander Lakhin, analysis and suggestion for the fix by
Tom Lane. Fixes bug #17828.

Reviewed-by: Alexander Lakhin, Thomas Munro
Discussion: https://www.postgresql.org/message-id/472235.1678387869@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/50c67c2019ab9ade8aa8768bfe604cd802fe8591

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out |  7 +++
contrib/postgres_fdw/sql/postgres_fdw.sql      |  6 +++
src/backend/executor/nodeAppend.c              |  5 +-
src/backend/libpq/pqcomm.c                     |  2 +-
src/backend/postmaster/postmaster.c            |  2 +-
src/backend/postmaster/syslogger.c             |  2 +-
src/backend/storage/ipc/latch.c                | 68 +++++++++++++++++++++++---
src/include/storage/latch.h                    |  4 +-
src/include/utils/resowner.h                   |  1 +
9 files changed, 84 insertions(+), 13 deletions(-)