Patche 19: Porovnání verzí

Z PostgreSQL

Skočit na navigaci Skočit na vyhledávání

← Porovnání se starší verzí Porovnání s novější verzí →

Verze z 11. 4. 2026, 04:05

~~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)
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4019f725f5d43f37b23222d06d20e3da1038d373 - statistiky pro zamky
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e2f289e5b9b82acaf1523fda827e71b8fc8bd549 - soft errors cast - priprava na fault tolerant CAST
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=497c1170cb108cd84fe13db19c049177376fec5f - podpora base32hex
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=41d69e6dccad6ef26511a466e6484bc8807362cf - popisky v internich psql dotazech
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity~~
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT~~
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)~~
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a - get pg_get_database_ddl~~
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=76e514ebb4b55f95b844e3e94e61fa64ab16fd0b - get_object_ddl~~
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e8ec19aa321abc89fb4fd277c994f14680ba17db - pg_stash_advice
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e972dff6c30447ebcfa2f8601b67f926247463b6 - moznost nastaveni explainu v auto-explainu
~~https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28d534e2ae0ac888b5460f977a10cd9bb017ef98 - REPACK CONCURRENTLY (zatim s omezenim)~~
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87f61f0c82806b7e4201f15bd77920e9e7108b11 - pohled pg_stat_autovacuum_scores
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru

Citováno z „http://postgres.cz/index.php?title=Patche_19&oldid=1531“