Patche 19: Porovnání verzí

Z PostgreSQL
Skočit na navigaci Skočit na vyhledávání
Bez shrnutí editace
Bez shrnutí editace
 
(Není zobrazena jedna mezilehlá verze od stejného uživatele.)
Řádek 46: Řádek 46:
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4a1b05caa55dc14a1f936af78d8d19c843bfd8b9 - znovu povolena podpora AIX</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4a1b05caa55dc14a1f936af78d8d19c843bfd8b9 - znovu povolena podpora AIX</s>
* <s>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/</s>
* <s>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/</s>
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba97bf9cb7b4ca184ab669569be2633a46cfdd0c - podpora dumpu extended expr statistik
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba97bf9cb7b4ca184ab669569be2633a46cfdd0c - podpora dumpu extended expr statistik</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a525cc97e19868940c533787165bc7e7de3a80a - copy on error set null</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a525cc97e19868940c533787165bc7e7de3a80a - copy on error set null</s>
* https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/
* https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/
Řádek 74: Řádek 74:
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=497c1170cb108cd84fe13db19c049177376fec5f - podpora base32hex</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=497c1170cb108cd84fe13db19c049177376fec5f - podpora base32hex</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=41d69e6dccad6ef26511a466e6484bc8807362cf - popisky v internich psql dotazech</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=41d69e6dccad6ef26511a466e6484bc8807362cf - popisky v internich psql dotazech</s>
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</s>
* 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=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF
Řádek 85: Řádek 85:
* 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=e972dff6c30447ebcfa2f8601b67f926247463b6 - moznost nastaveni explainu v auto-explainu
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28d534e2ae0ac888b5460f977a10cd9bb017ef98 - REPACK CONCURRENTLY (zatim s omezenim)</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28d534e2ae0ac888b5460f977a10cd9bb017ef98 - REPACK CONCURRENTLY (zatim s omezenim)</s>
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87f61f0c82806b7e4201f15bd77920e9e7108b11 - pohled pg_stat_autovacuum_scores
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87f61f0c82806b7e4201f15bd77920e9e7108b11 - pohled pg_stat_autovacuum_scores</s>
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</s>
* 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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty
* <s>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</s>
* <s>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</s>
* 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=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru

Aktuální verze z 15. 4. 2026, 19:18

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