PostgreSQL 14 Open Items

Open Issues

NOTE: Please place new open items at the end of the list.

None!

Older bugs affecting stable branches

Live issues

• REINDEX on a system catalog can leave index with two index tuples whose heap TIDs match
  • In other words, there is a rare case where the HOT invariant is violated. Same HOT chain is indexed twice due to confusion about which precise heap tuple should be indexed.
  • Unclear what the user impact is.
  • Affects all stable branches.

• CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers
  • tgenabled lost on CREATE TABLE .. PARTITION OF, and on pg_dump, and comments on child triggers lost during pg_dump;
  • Those are resolved by f0e21f2f6 and df80fa2ee, but there's another issue with psql \d of non-inherited triggers

• memory leak with JIT inlining
  • Another report of (same?) issue and reproducer
  • Another report
  • Another report

• could not rename temporary statistics file on Windows
  • See 909b449e00fc2f71e1a38569bbddbb6457d28485 that has fixed a similar symptom for WAL segments. Most reporters of the WAL segment problem complained about this renaming issue as well.

• Incorrect snapshot calculation when 2PC is in use
  • Seems to be an old problem.

Fixed issues

• hashagg broken by failing to spill grouping columns
  • Fixed at: 0ff865fbe50e82f17df8a9280fa01faf270b7f3f

• PITR promote bug: Checkpointer writes to older timeline
  • Fixed at: 595b9cba2ab0cdd057e02d3c23f34a8bcfd90a2d

• Permission failures with WAL files in 13~ on Windows
  • Fixed at: 78c24e97dd189f62187a99ef84016d0eb35a7978

• CLOBBER_CACHE Server crashed with segfault 11 while executing clusterdb
  • Fixed at: 9d523119fd38fd205cb9c8ea8e7cceeb54355818

• Reference leak with tupledescs in plpgsql simple expressions
  • Fixed at: c2db458c1036efae503ce5e451f8369e64c99541

• extract(julian) is undocumented and gives wrong result
  • Fixed by documentation change at: 79a5928ebcb726b7061bf265b5c6990e835e8c4f

• lwlock dtrace probes do unnecessary work if dtrace is compiled in but disabled
  • Fixed at: b94409a02f6122d77b5154e481c0819fed6b4c95

• Detoast failures after commit/rollback in plpgsql
  • Fixed at: f21fadafaf0fb5ea4c9622d915972651273d62ce and 84f5c2908dad81e8622b0406beea580e40bb03ac

• Subscription tests fail under CLOBBER_CACHE_ALWAYS
  • Fixed at: b39630fd41f25b414d0ea9b30804f4105f2a0aff

• XX000: unknown type of jsonb container.
  • Fixed at: 6ee41a301e70fc8e4ad383bad22d695f66ccb0ac

• Buildfarm does not test pg_stat_statements
  • Fixed by buildfarm client change

• Parallel VACUUM operations cause the error "global/pg_filenode.map contains incorrect checksum"
  • Fixed at: b6d8d207 and 9b8ed0f52

• Assertion failure in HEAD and 13 after calling COMMIT in a stored proc
  • Fixed at: d102aafb6259a6a412803d4b1d8c4f00aa17f67e

• Add PortalDrop in exec_execute_message
  • Fixed at: bb4aed46a and 4efcf47053

• snapshot-scalability logic fails after pg_upgrade, due to pg_resetwal issue
  • Now seems likely that this is an old issue affecting every release, and that the snapshot-scalability work is not at fault
  • Pending fix for pg_upgrade + pg_resetwal
  • Fixed at: 74cf7d46a91d601e0f8d957a7edbaeeb7df83efc

• Logical Decoding of relation rewrite with toast does not reset toast_hash
  • Problem exists since v11.
  • Fixed at: 29b5905470285bf730f6fe7cc5ddb3513d0e6945

• Consider back-patching typmod casting behavior change to stable branches
  • Fixed at: dede1439978120d2196e0d3963bb809a8b262e5b

Non-bugs

• progress reporting for partitioned REINDEX
• pg_regress and tablespace removal
  • Some patch

Resolved Issues

resolved before 14rc1

• EXPLAIN VERBOSE fails on query with SEARCH BREADTH FIRST
  • Fixed at: 3f50b82639637c9908afa2087de7588450aa866b

• pgstat_send_connstats() introduces unnecessary timestamp and UDP overhead
  • Fixed at: 37a9aa659111c454386b7055dcd3809e45bc17de

• Should we undo libpq change that leaves PQerrorMessage() nonempty after successful connect?
  • Fixed at: 138531f1bbc333745bd8422371c07e7e108d5528

• default setting of enable_memoize
  • No change required. (Discussed on Releases list)
  • Owner: David Rowley

• extended statistics: reject single-var expressions
  • Fixed at: 13380e1476490932c7b15530ead1f649a16e1125 - Extra parenthesis
  • Fixed at: 537ca68db - reject single-var expressions
  • Owner: Tomas Vondra

• pg_stats includes partitioned tables, but always shows analyze_count=0
  • Fixed at: e1efc5b465c844969a0ed0d07e1364f3ce424d8c

• Issues around autovacuum for partitioned tables
  • Feature reverted: b3d24cc0f0aa882ceec0a74a99f94166c6fc3247

• DECLARE STATEMENT and DEALLOCATE/DESCRIBE
  • Fixed at: 399edafa2aba562a8013fbe039f3cbf3a41a436e
  • Fixed at: f576de1db1eeca63180b1ffa4b42b1e360f88577

• Performance regression with hex refactoring code
  • Fixed at: 2576dcfb76aa71e4222bac5a3a43f71875bfa9e8

• elog.c query_id support vs shutdown
  • Fixed at: bed5eac2d50eb86a254861dcdea7b064d10c72cf

• wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
  • Fixed at: 1046a69b3087a6417e85cae9b6bc76caa22f913b

• BUG #17158 (type RECORD is not always hashable)
  • Fixed at: 054adca641ac1279dc8d9b74fda41948ac35e9a9

resolved before 14beta3

• \dX doesn't check pg_statistics_obj_is_visible()
  • Fixed at: f68b609230689f9886a46e5d9ab8d6cdd947e0dc

• remove_temp_files_after_crash should be a DEVELOPER GUC
  • Fixed at: 797b0fc0b078c7b4c46ef9f2d9e47aa2d98c6c63

• recovery_init_sync_method should be PGC_SIGHUP?
  • Fixed at: 34a8b64b4e5f0cd818e5cc7f98846de57938ea57

• OOM on palloc() when parsing service file would cause libpq to exit() without reporting a failure
  • Fixed at: 8ec00dc5cd70e0e579e9fbf8661bc46f5ccd8078
  • Additional defenses added at: dc227eb82ea8bf6919cd81a182a084589ddce7f3

• incorrect code for reporting the hash partition associated with a particular modulus
  • Fixed at: dd2364ced98553e0217bfe8f621cd4b0970db74a

• Bug in multirange selectivity estimation
  • Fixed at: 322e82b77ef4acb9697c6e4259292f5671cb85bb

• autoanalyze of partitioned table causes it to lose its relhasindex
  • Fixed at: d700518d744e53994fdded14b23ebc15b031b0dd

• Incorrect time maths in pgbench and second thread
  • Fixed at: 0e39a608ed5545cc6b9d538ac937c3c1ee8cdc36

• unnesting multirange data types
  • Fixed at: 244ad5415557812a6ac4dc5d6e2ae908361d82c3

• Cache lookup failed when null (unknown) is passed as anycompatiblemultirange
  • Fixed at: 336ea6e6ff1109e7b83370565e3cb211804fda0c

• Degraded out-of-memory handling in libpq
  • Fixed at: 514b4c11d24701d2cc90ad75ed787bf1380af673

• Crash in regexp with {0}
  • Fixed at: cc1868799c8311ed1cc3674df2c5e1374c914deb

resolved before 14beta2

• Snapshot scalability OldestXmin issue (can cause infinite loop during system catalog VACUUM)
  • Fixed at: 5a1e1d83022b976ebdec5cfa8f255c4278b75b8e

• Generalize INDEX_CLEANUP to allow the user to disable the optimization that has VACUUM skip indexes in marginal cases with very few LP_DEAD items/deletable TIDs.
  • Fixed at: 3499df0dee8c4ea51d264a674df5b5e31991319a

• Questions about pg_stat_wal also [1]
  • Fixed at: d8735b8b4651f5ed50afc472e236a8e6120f07f2
  • Fixed at: d780d7c0882fe9a385102b292907baaceb505ed0

• pg_dumpall misses --no-toast-compression
  • Fixed at: 694da1983e9569b2a2f96cd786ead6b8dba31f1d

• portability issue with pgbench's permute() function
  • Fixed at: 0f516d039d8023163e82fa51104052306068dd69

• compute_query_id and pg_stat_statements
  • Fixed at cafde58b33 and 354f32d01d

• Result Cache works incorrectly with unique joins
  • Fixed at 9e215378d7fbb7d4615be917917c52f246cc6c61

• Move pg_attribute.attcompression to earlier in struct for reduced size?
  • Fixed at f5024d8d7b04de2f5f4742ab433cc38160354861

• EXPLAIN can suffer from cannot decompile join alias var in plan tree
  • Fixed at cba5c70b956810c61b3778f7041f92fbb8065acb

• Memory leak when rewriting tuples with recompressed toast values
  • Fixed at fb0f5f0172edf9f63c8f70ea9c1ec043b61c770e

• Redefine pg_attribute.attcompression
  • Fixed at e6241d8e030fbd2746b3ea3f44e728224298f35b

• Undo bump of FirstBootstrapObjectId
  • Fixed at a4390abecf0f5152cff864e82b67e5f6c8489698

• Assertion failure while streaming toasted data
  • Fixed at 6f4bdf81529fdaf6744875b0be99ecb9bfb3b7e0

• Join pushdown issue in postgres_fdw updates
  • Fixed at f61db909dfb94f3411f8719916601a11a905b95e

• Performance degradation of REFRESH MATERIALIZED VIEW
  • Fixed at 8e03eb92e9ad54e2f1ed8b5a73617601f6262f81

• Rescan of async Appends is broken when do_exec_prune=false
  • Fixed at f3baaf28a6da588987b94a05a725894805c3eae9

• libpq dumps core while making an SSL connection to a server specified by hostaddr
  • Fixed at 37e1cce4ddf0be362e3093cee55493aee41bc423

• logical replication of truncate command with trigger causes Assert
  • Fixed at 3a09d75b4f6cabc8331e228b6988dbfcd9afdfbe

• Reconsider catalog representation and uniqueness rules for procedures with output-only arguments
  • Fixed at e56bce5d43789cce95d099554ae9593ada92b3b7

• Performance regression of VACUUM FULL with the addition of recompression path in tuple rewrite
  • Fixed at dbab0c07e5ba1f19a991da2d72972a8fe9a41bda

• Document incompatibility with aggregates using system functions using anycompatiblearray
  • Fixed at 25dfb5a831a1b8a83a8a68453b4bbe38a5ef737e

resolved before 14beta1

• FailedAssertion reported in lazy_scan_heap() when running logical replication
  • Fixed at: c9787385db47ba423d845b34d58e158551c6335d

• Assertion fail with window function and nested partitioned tables
  • Older report
  • Fixed at: fb2d645dd53ff571572d830e830fc8c368063802

• Atomic initialization of waitStart done at backend startup
  • Fixed at: f05ed5a5cfa55878baa77a1e39d68cb09793b477

• pg_collation_actual_version() ERROR: cache lookup failed for collation 123
  • Fixed at: 0fb0a0503bfc125764c8dba4f515058145dc7f8b

• cryptohash: missing locking functions for OpenSSL <= 1.0.2?
  • Fixed at: 2c0cefcd18161549e9e8b103f46c0f65fca84d99

• pg_subscription - substream column?
  • Fixed at: 7efeb214ad832fa96ea950d0906b1d2b96316d15

• TOAST compression method of index columns
  • Fixed at: 5db1fd7823a1a12e2bdad98abc8e102fd71ffbda

• Crash with encoding conversion functions
  • Fixed at: c4c393b3ec83ceb4b4d7f37cdd5302126377d069

• Crash with extended stats on expressions
  • Fixed at: 518442c7f334f3b05ea28b7ef50f1b551cfcc23e

• Update TOAST documentation for LZ4 compression
  • Fixed at: e8c435a824e123f43067ce6f69d66f14cfb8815e

• Behavior of pg_dump --extension with schemas
  • Fixed at: 344487e2db03f3cec13685a839dbc8a0e2a36750

• psql query cancellation is broken, as are autocommit, and error reporting
  • Reverted by: fae65629cec824738ee11bf60f757239906d64fa

• On Windows, collation version lookup (sometimes?) fails for names like "English_United States.1252", but works for names like "en-US".
  • Fixed at: 9f12a3b95dd56c897f1aa3d756d8fb419e84a187 -- this commit tolerates failure so at least we don't raise an error, but unfortunately we have no version information
  • Fixed at: 1bf946bd43e545b86e567588b791311fe4e36a8c -- this commit documents the limitation

• Handling of querystring inconsistent for parallel execution of SQL function bodies
  • Fixed at: 1111b2668d89bfcb6f502789158b1233ab4217a6

• Problems around compute_query_id
  • Fixed at: db01f797dd48f826c62e1b8eea70f11fe7ff3efc

• Table reference leak in logical replication
  • Fixed at: f3b141c482552a57866c72919007d6481cd59ee3

• DETACH PARTITION CONCURRENTLY: Avoid adding redundant constraint
  • Fixed at: 7b357cc6ae

• Issues in PostgresNode and older major versions with multi-install
  • Fixed at 95c3a1956ec9eac686c1b69b033dd79211b72343 and 4c4eaf3d19201c5e2d9efebc590903dfaba0d3e5

• DETACH PARTITION CONCURRENTLY tests fail under CLOBBER_CACHE_ALWAYS
  • Fixed at: 8aba9322511f

• TRUNCATE on foreign tables and ONLY clause
  • Fixed at: 8e9ea08bae93a754d5075b7bc9c0b2bc71958bfd

• handling of character continuation in psql broken by sql body patch
  • Fixed at: d9a9f4b4b92ad39e3c4e6600dc61d5603ddd6e24

• cache lookup failed for statistics object 123
  • Fixed at: 8d4b311d2494ca592e30aed03b29854d864eb846

• batch fdw insert bug
  • Fixed at: c6a01d924939306e95c8deafd09352be6a955648

• Bogus collation version recording in recordMultipleDependencies
  • Fixed at: ec48314708262d8ea6cdcb83f803fc83dd89e721 (Feature revert)

• Corruption issues with WAL prefetch?
  • Fixed at: c2dc19342e05e081dc13b296787baa38352681ef (Feature revert)

• Small issues with CREATE TABLE COMPRESSION
  • MSVC scripts don't support builds with lz4: fixed at 9ca40dcd4d0cad43d95a9a253fafaa9a9ba7de24
  • pg_dump includes no tests with compression methods of attributes and --no-toast-compression: fixed at 63db0ac3f9e6bae313da67f640c95c0045b7f0ee
  • Documentation missing for --with-lz4 in installation instructions: fixed at 02a93e7ef9612788081ef07ea1bbd0a8cc99ae99

• Replication slot stats misgivings
  • Fixed at: 3fa17d37716f978f80dfcdab4e7c73f3a24e7a48
  • Fixed at: 592f00f8dec68038301467a904ac514eddabf6cd
  • Fixed at: cca57c1d9bf7eeba5b81115e0b82651cf3d8e4ea
  • Fixed at: f5fc2f5b23d1b1dff60f8ca5dc211161df47eda4

• FDW: crash with DDL and async/batch option
  • Fixed at: a784859f4480ceaa05a00ca35311071ca33483d1

• should autoanalyze for partitioned tables handle ATTACH/DETACH/DROP?
  • Fixed at: 1b5617eb844cd2470a334c1d2eec66cf9b39c41a (docs)

• OOM in spgist insert
  • Fixed at: c3c35a733c77b298d3cf7e7de2eeb4aea540a631

Won't Fix

• SQL-standard function body: pg_dump should handle circular dependencies
  • Owner: Peter Eisentraut
• SEARCH BREADTH FIRST produces a composite column whose fields can't be accessed
  • Owner: Peter Eisentraut

Important Dates

Current schedule:

• Feature Freeze: April 7, 2021 (Last Day to Commit Features)
• Beta 1: May 20, 2021
• Beta 2: June 24, 2021
• Beta 3: August 12, 2021
• RC 1: September 23, 2021
• GA: tentatively September 30, 2021