Patche 19

• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd09f024a1bbdd7a7e2ca944595a9d4b6c90fb83 - regdatabase
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0da29e4cb161f78a5ef534b3fb4467756a422e25 - podpora memoize v anti joinu (v nekterych pripadech)
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fe07100e82b096d3c848cace790d4b4daf0c4131 - GetNamedDSA(), GetNamedDSHash() - user friendly alokace dynamicke sdilene pameti
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=167ed8082f40ee1f3f4cd18cf02bd6d17df57dab - pohled pg_dsm_registry_allocations
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f698d7f4b7b4c49c3649b2fcc063eb66f9d2e6c - možnost konfigurace příkazu CHECKPOINT
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=161a3e8b682ebb98ea0b9d5015d22990696b99ec - použití COPY pro LO
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3357471cf9f5e470dfed0c7919bcf31c7efaf2b9 - přidání typu plánu do pg_stat_statements
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd5a1a0c3e566f7fc860838084466a1c25944281 - reseni konfliktu delete/update
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=665c3dbba497b795c4ee46145777bc4eb89c78a1 - příprava na 64bit Datum i na 32bit platformách
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a600a93c7be5b0bf8cacb1af78009db12bc4857 - Datum je 8bajt všude
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24225ad9aafc576295e210026d8ffa9f50d61145 - vylepšená optimalizace semijoinu
• prechod z c99 na c11
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=63599896545c7869f7dd28cd593e8b548983d613 - generování GUC z dat souboru
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=faf071b553830d39fc583beabcaf56ed65259acc - random funkce pro date a timestamp
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=83a56419457ec0eff2eddfed8eb3aba86bede9cc - vylepsene chybove hlaseni nenalezeni funkce
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e1d917182c1953b16b32a39ed2fe38e3d0823047 - podpora kodovani base64url
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ef38a4d9756db9ae1d20f40aa39f3cf76059b81a - GROUP BY ALL
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=25a30bbd4235a49c854036c84fe90f2bc5a87652 - IGNORE NULL pro window funkce
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ec8719ccbfcd78c6b40b5f2b94f60769f3bd08aa - optimalizace hex encode decode pouziti simd
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8e11859102f947e6145acdd809e5cdcdfbe90fa5 - moznost predradit agregaci joinu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4bea91f21f61d01bd40a4191a4a8c82d0959fffe - copy dokaze cist primo z partisen
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2b75c38b707a070922231de667a0bd08ee71b268 - funkce error_on_null - pozor nefunguje korektne s radkovymi typy
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f0b3573c3aac6c0ea4cbc278f98178516579d370 - podpora synchronizace sekvenci https://www.depesz.com/2025/11/11/waiting-for-postgresql-19-sequence-synchronization-in-logical-replication/
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5173bfd0443e0c0f3fa37006727d516dc1ba4cee - rychlejsi pg_rewind
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f9a09aa2952039a9956b44d929b9df74d62a4cd4 - v pg_stat_wal zobrazi bajty způsobené zápisem full pages
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b3ce55f413cdf70b1bc4724052fb4eacf9de239a - psql moznost v promptu zobrazit search_path
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=645cb44c5490f70da4dca57b8ecca6562fb883a7 - psql moznost nastavit si nahradni text za t a f
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=447aae13b0305780e87cac7b0dd669db6fab3d9d - WAIT FOR lsn
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b140c8d7a3f3a5de4e4cc4a0b52909aa13060d4c - moznost inline dotaz dynamicky dotaz z plpgsql
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7 - slotsync_skip_reason
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa - 64bit multixid
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67c20979ce72b8c236622e5603f9775968ff501c - moznost pouzivat logickou replikaci bez restartu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f2e4cc427951b7c46629fb7625a22f7898586f3a - MERGE PARTITIONS
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4b3d173629f4cd7ab6cd700d1053af5d5c7c9e37 - SPLIT PARTITIONS
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=97b101776ce23dd6c4abbdae213806bc24ed6133 - monitoring multiactu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b139bd3b6ef000ab5d00dd47128e366a726da5f9 - datovy typ oid8
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=282b1cde9dedf456ecf02eb27caf086023a7bb71 - optimalizace LISTEN
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fcb9c977aa5f1eefe7444e423e833ff64a5d1d8f - specialni zamky pro buffmgr
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=45762084545ec14dbbe66ace1d69d7e89f8978ac - odstraneni podpora pro defaultni postgresove retezce
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0e80f3f88deaefc03e5fd204190daab6f761e73d - moznost dumpu extended statistik
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=38e0190ced714b33c43c9676d768cc6814fc662a - možnost nastavit logování per typ dotazu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0a379612540cc51e54dc1c0cc4b9ef8797d2533c - optimalizace IS DISTINCT FROM pro ne nullove hodnoty
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f41ab51573a4c3d11f906b32a068182a1fd8596d - optimalizace IS DISTINCT FROM NULL
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cf74558feb8f41b2bc459f59ed3f991024d04893 - redukce specialnich pripadu outer joinu na antijoin
• https://www.depesz.com/2026/02/21/waiting-for-postgresql-19-psql-add-i-prompt-escape-to-indicate-hot-standby-status/ - moznost v promtu nastavit stav replikace
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4a1b05caa55dc14a1f936af78d8d19c843bfd8b9 - znovu povolena podpora AIX
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=763aaa06f03401584d07db71256fc0ab47235cce - pg_dumpall muze ukladat i v jinem nez textovem formatu https://www.depesz.com/2026/03/17/waiting-for-postgresql-19-add-non-text-output-formats-to-pg_dumpall/
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba97bf9cb7b4ca184ab669569be2633a46cfdd0c - podpora dumpu extended expr statistik
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a525cc97e19868940c533787165bc7e7de3a80a - copy on error set null
• https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7c1849311e49ec57cb86b32a9aa630456588c3f0 - vychozi komprese wal je lz4
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd366065e06ae953c4f2d973d5c5f0474f3b87b6 - CREATE PUBLICATION EXCEPT TABLE
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34dfca293432e206b8f80431f81535aff69782ca - vychozi komprese TOAST je lz4
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01d485b142e4c89aef79da9fd60f203c1bd4458b - novy pohled pg_stat_recovery
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8185bb53476378443240d57f7d844347d5fae1bf - CREATE SUBSCRIPTION SERVER
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ac58465e0618941842439eb3f5a2cf8bebd5a3f1 - REPACK
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=342051d73b386ad763e13930e15031f7ba5367f5 - ALTER TABLE ALTER CHECK NOT ENFORCED
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=383eb21ebffe9ddd97dca03e529fa363580e7ccf - konverze NOT IN (SELECT) na antijoin
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5883ff30b02ceed3c5eabba4d9c09a7766f9a8fc - pg_plan_advice v contribu https://www.depesz.com/2026/03/22/waiting-for-postgresql-19-add-pg_plan_advice-contrib-module/
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a0b6ef29a51818a4073a5f390ed10ef6453d5c11 - umoznuje rychly ALTER TABLE ALTERL COLUMN i pro domenove typy
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=213f0079b3415ad8f5f0a62d119ed1f0a448ad8f - pgstattuple pouziva streaming

https://postgrespro.com/blog/pgsql/5972812

• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e0a3a3fd5361913502ff696ecf47770ca55975ae - optimalizace COPY FROM simd
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c456e39113809376f6604e720910ccd24e18e034 - optimalizace transformace heaptuple na radek
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f094e7ac691abc9d2fe0f4dcf0feac4a6ce1d9c - podpora SQL/PGQ
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1811f1af98fb237fdd5adb588cd4b57c433b75f8 - výrazně lepší chování HASHJOINu s velkým množstvím NULL hodnot
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=493f8c6439cf64d75883c650b5dd573d8fe0664b - ALTER PUBLICATION EXCEPT TABLE
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7dadd38cda95bf5bc0c4715d9ab71766d1693379 - COPY TO v jsonu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4c0390ac53b745c2800f6aa3d9ee2515d6ab499b - COPY TO JSON force_array
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ce8d5fe0e2802158b65699aeae1551d489948167 - optimalizace SELECT const INTO var (v plpgsql)