[Commitfest 2022-07] Patch Triage: Needs Review, Part 2

Hello,

Part 2 should include entries four commitfests and older. (For the rest,
it's probably too early to call something "stalled", so I don't plan to
do any more triage there.) Patch authors CC'd.

= Stalled Patches, Recommend Return =

I plan to return these with a note saying "needs more interest".

- Extended statistics in EXPLAIN
  https://commitfest.postgresql.org/38/3050/

  There's interest, but it seemed controversial. And a reviewer
  attempted to revive this in January, but there hasn't been new
  engagement or response from the original people involved in a year.

- Map WAL segment files on PMEM as WAL buffers
  https://commitfest.postgresql.org/38/3181/

  Stalled out; last review was in January and it needs a rebase.

- Support pg_ident mapping for LDAP
  https://commitfest.postgresql.org/38/3314/

  This one's mine; I think it's clear that there's not enough interest
  in this idea yet and I think I'd rather put effort into SASL, which
  would ideally do the same thing natively.

- Improve logging when using Huge Pages
  https://commitfest.postgresql.org/38/3310/

  There was interest last year but no mails this year, so this probably
  needs some buy-in first.

- functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)
  https://commitfest.postgresql.org/38/3256/

  Been rebasing without review since September 2021. Seems like there's
  an idea in here that people want, though. Any sponsors for a future
  CF?

- Upgrade pgcrypto to crypt_blowfish 1.3
  https://commitfest.postgresql.org/38/3338/

  No conversation on this since October 2021. Like above, seems like a
  reasonable feature, so maybe someone can sponsor it and quickly get it
  resurrected in a future CF?

= Stalled Patches, Need Help =

I plan to move these forward unless someone says otherwise, but they
look stuck to me and need assistance.

- pgbench: add multiconnect support
  https://commitfest.postgresql.org/38/3227/

  Seems to be interest. Not much review, though.

- pg_stats and range statistics
  https://commitfest.postgresql.org/38/3184/

  There was immediate agreement that this feature was desirable, and
  then the reviews dried up. Anyone want to bump this?

- Asymmetric partition-wise JOIN
  https://commitfest.postgresql.org/38/3099/

  There was a rebase in January by a reviewer, so there's definite
  interest, but work hasn't progressed in a while. I've marked Waiting
  on Author in the meantime.

- Logging plan of the currently running query
  https://commitfest.postgresql.org/38/3142/

  Last review in Febrary and currently in a rebase loop.

- schema change not getting invalidated, both renamed table and new
  table data were getting replicated
  https://commitfest.postgresql.org/38/3262/

  This looks like a bug fix that should not be closed out, but it's been
  in a rebase loop without review for... a year? Any takers? Should we
  make an open issue?

- pgbench: using prepared BEGIN statement in a pipeline could cause an
  error
  https://commitfest.postgresql.org/38/3260/

  A bug fix, but maybe the approach taken for the fix is controversial?

- Atomic rename feature for Windows
  https://commitfest.postgresql.org/38/3347/

  I think this got derailed by a committer conversation about platform
  deprecation? I have no idea where the patch stands after that
  exchange; can someone recap?

= Active Patches =

These will be moved ahead:

- Lazy JIT IR code generation to increase JIT speed with partitions
- Logical replication failure "ERROR: could not map filenode
  "base/13237/442428" to relation OID" with catalog modifying txns
- Add proper planner support for ORDER BY / DISTINCT aggregates
- Fix ExecRTCheckPerms() inefficiency with many prunable partitions
- Using each rel as both outer and inner for anti-joins
- Postgres picks suboptimal index after building extended statistics
- Cache tuple routing info during bulk loads into partitioned tables
- postgres_fdw: commit remote (sub)transactions in parallel during
  pre-commit
- add checkpoint stats of snapshot and mapping files of pg_logical dir
- Allows database-specific role memberships

Thanks,
--Jacob