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