http://postgres.cz/index.php?action=history&feed=atom&title=Patche_19
Patche 19 - Historie editací
2026-05-30T00:17:25Z
Historie editací této stránky
MediaWiki 1.43.3
http://postgres.cz/index.php?title=Patche_19&diff=1579&oldid=prev
PavelStehule v 21. 4. 2026, 11:38
2026-04-21T11:38:07Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 11:38</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l76">Řádek 76:</td>
<td colspan="2" class="diff-lineno">Řádek 76:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</s></div></td></tr>
<!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1578:rev-1579:php=table -->
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1578&oldid=prev
PavelStehule v 21. 4. 2026, 10:37
2026-04-21T10:37:28Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 10:37</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l57">Řádek 57:</td>
<td colspan="2" class="diff-lineno">Řádek 57:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=342051d73b386ad763e13930e15031f7ba5367f5 - ALTER TABLE ALTER CHECK NOT ENFORCED</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=342051d73b386ad763e13930e15031f7ba5367f5 - ALTER TABLE ALTER CHECK NOT ENFORCED</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=383eb21ebffe9ddd97dca03e529fa363580e7ccf - konverze NOT IN (SELECT) na antijoin</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=383eb21ebffe9ddd97dca03e529fa363580e7ccf - konverze NOT IN (SELECT) na antijoin</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* 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/</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>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/<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a0b6ef29a51818a4073a5f390ed10ef6453d5c11 - umoznuje rychly ALTER TABLE ALTERL COLUMN i pro domenove typy</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a0b6ef29a51818a4073a5f390ed10ef6453d5c11 - umoznuje rychly ALTER TABLE ALTERL COLUMN i pro domenove typy</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=213f0079b3415ad8f5f0a62d119ed1f0a448ad8f - pgstattuple pouziva streaming</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=213f0079b3415ad8f5f0a62d119ed1f0a448ad8f - pgstattuple pouziva streaming</s></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l87">Řádek 87:</td>
<td colspan="2" class="diff-lineno">Řádek 87:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87f61f0c82806b7e4201f15bd77920e9e7108b11 - pohled pg_stat_autovacuum_scores</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=87f61f0c82806b7e4201f15bd77920e9e7108b11 - pohled pg_stat_autovacuum_scores</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <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></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <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></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1577&oldid=prev
PavelStehule v 21. 4. 2026, 04:22
2026-04-21T04:22:00Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 04:22</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l28">Řádek 28:</td>
<td colspan="2" class="diff-lineno">Řádek 28:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=447aae13b0305780e87cac7b0dd669db6fab3d9d - WAIT FOR lsn</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=447aae13b0305780e87cac7b0dd669db6fab3d9d - WAIT FOR lsn</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b140c8d7a3f3a5de4e4cc4a0b52909aa13060d4c - [https://www.thatguyfromdelhi.com/2025/11/teaching-query-planner-to-see-inside-c.html moznost inline dotaz dynamicky dotaz z plpgsql]</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b140c8d7a3f3a5de4e4cc4a0b52909aa13060d4c - [https://www.thatguyfromdelhi.com/2025/11/teaching-query-planner-to-see-inside-c.html moznost inline dotaz dynamicky dotaz z plpgsql]</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7 - slotsync_skip_reason</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7 - slotsync_skip_reason<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa - 64bit multixid</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa - 64bit multixid</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67c20979ce72b8c236622e5603f9775968ff501c - moznost pouzivat logickou replikaci bez restartu</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67c20979ce72b8c236622e5603f9775968ff501c - moznost pouzivat logickou replikaci bez restartu</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1576&oldid=prev
PavelStehule v 21. 4. 2026, 04:21
2026-04-21T04:21:28Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 04:21</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Řádek 6:</td>
<td colspan="2" class="diff-lineno">Řádek 6:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=161a3e8b682ebb98ea0b9d5015d22990696b99ec - použití COPY pro LO</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=161a3e8b682ebb98ea0b9d5015d22990696b99ec - použití COPY pro LO</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3357471cf9f5e470dfed0c7919bcf31c7efaf2b9 - přidání typu plánu do pg_stat_statements</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3357471cf9f5e470dfed0c7919bcf31c7efaf2b9 - přidání typu plánu do pg_stat_statements</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd5a1a0c3e566f7fc860838084466a1c25944281 - reseni konfliktu delete/update</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd5a1a0c3e566f7fc860838084466a1c25944281 - reseni konfliktu delete/update<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=665c3dbba497b795c4ee46145777bc4eb89c78a1 - příprava na 64bit Datum i na 32bit platformách</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=665c3dbba497b795c4ee46145777bc4eb89c78a1 - příprava na 64bit Datum i na 32bit platformách</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a600a93c7be5b0bf8cacb1af78009db12bc4857 - Datum je 8bajt všude</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a600a93c7be5b0bf8cacb1af78009db12bc4857 - Datum je 8bajt všude</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1575&oldid=prev
PavelStehule v 21. 4. 2026, 03:45
2026-04-21T03:45:46Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 03:45</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l82">Řádek 82:</td>
<td colspan="2" class="diff-lineno">Řádek 82:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a - get pg_get_database_ddl</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a - get pg_get_database_ddl</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=76e514ebb4b55f95b844e3e94e61fa64ab16fd0b - get_object_ddl</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=76e514ebb4b55f95b844e3e94e61fa64ab16fd0b - get_object_ddl</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e8ec19aa321abc89fb4fd277c994f14680ba17db - pg_stash_advice</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e8ec19aa321abc89fb4fd277c994f14680ba17db - pg_stash_advice<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e972dff6c30447ebcfa2f8601b67f926247463b6 - moznost nastaveni explainu v auto-explainu</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e972dff6c30447ebcfa2f8601b67f926247463b6 - moznost nastaveni explainu v auto-explainu</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28d534e2ae0ac888b5460f977a10cd9bb017ef98 - REPACK CONCURRENTLY (zatim s omezenim)</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28d534e2ae0ac888b5460f977a10cd9bb017ef98 - REPACK CONCURRENTLY (zatim s omezenim)</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1574&oldid=prev
PavelStehule v 21. 4. 2026, 03:39
2026-04-21T03:39:57Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 03:39</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l53">Řádek 53:</td>
<td colspan="2" class="diff-lineno">Řádek 53:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34dfca293432e206b8f80431f81535aff69782ca - vychozi komprese TOAST je lz4</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34dfca293432e206b8f80431f81535aff69782ca - vychozi komprese TOAST je lz4</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01d485b142e4c89aef79da9fd60f203c1bd4458b - novy pohled pg_stat_recovery</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01d485b142e4c89aef79da9fd60f203c1bd4458b - novy pohled pg_stat_recovery</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8185bb53476378443240d57f7d844347d5fae1bf - CREATE SUBSCRIPTION SERVER</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8185bb53476378443240d57f7d844347d5fae1bf - CREATE SUBSCRIPTION SERVER<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ac58465e0618941842439eb3f5a2cf8bebd5a3f1 - REPACK</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ac58465e0618941842439eb3f5a2cf8bebd5a3f1 - REPACK</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=342051d73b386ad763e13930e15031f7ba5367f5 - ALTER TABLE ALTER CHECK NOT ENFORCED</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=342051d73b386ad763e13930e15031f7ba5367f5 - ALTER TABLE ALTER CHECK NOT ENFORCED</s></div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l66">Řádek 66:</td>
<td colspan="2" class="diff-lineno">Řádek 66:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=493f8c6439cf64d75883c650b5dd573d8fe0664b - ALTER PUBLICATION EXCEPT TABLE</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=493f8c6439cf64d75883c650b5dd573d8fe0664b - ALTER PUBLICATION EXCEPT TABLE<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7dadd38cda95bf5bc0c4715d9ab71766d1693379 - COPY TO v jsonu</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7dadd38cda95bf5bc0c4715d9ab71766d1693379 - COPY TO v jsonu</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4c0390ac53b745c2800f6aa3d9ee2515d6ab499b - COPY TO JSON force_array</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4c0390ac53b745c2800f6aa3d9ee2515d6ab499b - COPY TO JSON force_array</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1573&oldid=prev
PavelStehule v 21. 4. 2026, 03:31
2026-04-21T03:31:17Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 03:31</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l50">Řádek 50:</td>
<td colspan="2" class="diff-lineno">Řádek 50:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://www.cybertec-postgresql.com/en/insert-on-conflict-do-select-a-new-feature-in-postgresql-v19/</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7c1849311e49ec57cb86b32a9aa630456588c3f0 - vychozi komprese wal je lz4</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7c1849311e49ec57cb86b32a9aa630456588c3f0 - vychozi komprese wal je lz4</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd366065e06ae953c4f2d973d5c5f0474f3b87b6 - CREATE PUBLICATION EXCEPT TABLE</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fd366065e06ae953c4f2d973d5c5f0474f3b87b6 - CREATE PUBLICATION EXCEPT TABLE<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34dfca293432e206b8f80431f81535aff69782ca - vychozi komprese TOAST je lz4</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=34dfca293432e206b8f80431f81535aff69782ca - vychozi komprese TOAST je lz4</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01d485b142e4c89aef79da9fd60f203c1bd4458b - novy pohled pg_stat_recovery</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=01d485b142e4c89aef79da9fd60f203c1bd4458b - novy pohled pg_stat_recovery</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1572&oldid=prev
PavelStehule v 21. 4. 2026, 03:28
2026-04-21T03:28:12Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 21. 4. 2026, 03:28</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21">Řádek 21:</td>
<td colspan="2" class="diff-lineno">Řádek 21:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4bea91f21f61d01bd40a4191a4a8c82d0959fffe - copy dokaze cist primo z partisen</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4bea91f21f61d01bd40a4191a4a8c82d0959fffe - copy dokaze cist primo z partisen</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2b75c38b707a070922231de667a0bd08ee71b268 - funkce error_on_null - pozor nefunguje korektne s radkovymi typy</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2b75c38b707a070922231de667a0bd08ee71b268 - funkce error_on_null - pozor nefunguje korektne s radkovymi typy</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* 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/</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>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/<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5173bfd0443e0c0f3fa37006727d516dc1ba4cee - rychlejsi pg_rewind</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5173bfd0443e0c0f3fa37006727d516dc1ba4cee - rychlejsi pg_rewind</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f9a09aa2952039a9956b44d929b9df74d62a4cd4 - v pg_stat_wal zobrazi bajty způsobené zápisem full pages</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f9a09aa2952039a9956b44d929b9df74d62a4cd4 - v pg_stat_wal zobrazi bajty způsobené zápisem full pages</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1571&oldid=prev
PavelStehule v 20. 4. 2026, 11:12
2026-04-20T11:12:40Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 20. 4. 2026, 11:12</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l63">Řádek 63:</td>
<td colspan="2" class="diff-lineno">Řádek 63:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e0a3a3fd5361913502ff696ecf47770ca55975ae - optimalizace COPY FROM simd</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e0a3a3fd5361913502ff696ecf47770ca55975ae - optimalizace COPY FROM simd</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c456e39113809376f6604e720910ccd24e18e034 - optimalizace transformace heaptuple na radek</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c456e39113809376f6604e720910ccd24e18e034 - optimalizace transformace heaptuple na radek</s></div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f094e7ac691abc9d2fe0f4dcf0feac4a6ce1d9c - podpora SQL/PGQ</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f094e7ac691abc9d2fe0f4dcf0feac4a6ce1d9c - podpora SQL/PGQ<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td></tr>
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1570&oldid=prev
PavelStehule v 19. 4. 2026, 11:29
2026-04-19T11:29:55Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="cs">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 19. 4. 2026, 11:29</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l64">Řádek 64:</td>
<td colspan="2" class="diff-lineno">Řádek 64:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c456e39113809376f6604e720910ccd24e18e034 - optimalizace transformace heaptuple na radek</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c456e39113809376f6604e720910ccd24e18e034 - optimalizace transformace heaptuple na radek</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f094e7ac691abc9d2fe0f4dcf0feac4a6ce1d9c - podpora SQL/PGQ</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f094e7ac691abc9d2fe0f4dcf0feac4a6ce1d9c - podpora SQL/PGQ</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* <ins style="font-weight: bold; text-decoration: none;"><s></ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dd1398f1378799acc60c3ed85d82439b2ff69141 - moznost urcit grantora v prikazu GRANT, REVOKE<ins style="font-weight: bold; text-decoration: none;"></s></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* <s>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</s></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=493f8c6439cf64d75883c650b5dd573d8fe0664b - ALTER PUBLICATION EXCEPT TABLE</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=493f8c6439cf64d75883c650b5dd573d8fe0664b - ALTER PUBLICATION EXCEPT TABLE</div></td></tr>
</table>
PavelStehule