http://postgres.cz/index.php?action=history&feed=atom&title=Patche_19 2026-04-09T18:42:07Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Patche_19&diff=1525&oldid=prev 2026-04-09T11:41:15Z

<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 9. 4. 2026, 11:41</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l35">Řádek 35:</td> <td colspan="2" class="diff-lineno">Řádek 35:</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=97b101776ce23dd6c4abbdae213806bc24ed6133 - monitoring multiactu</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=97b101776ce23dd6c4abbdae213806bc24ed6133 - monitoring multiactu</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=b139bd3b6ef000ab5d00dd47128e366a726da5f9 - datovy typ oid8</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=b139bd3b6ef000ab5d00dd47128e366a726da5f9 - datovy typ oid8</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=282b1cde9dedf456ecf02eb27caf086023a7bb71 - optimalizace LISTEN</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=282b1cde9dedf456ecf02eb27caf086023a7bb71 - optimalizace LISTEN<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fcb9c977aa5f1eefe7444e423e833ff64a5d1d8f - specialni zamky pro buffmgr</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=fcb9c977aa5f1eefe7444e423e833ff64a5d1d8f - specialni zamky pro buffmgr</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=45762084545ec14dbbe66ace1d69d7e89f8978ac - odstraneni podpora pro defaultni postgresove retezce</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=45762084545ec14dbbe66ace1d69d7e89f8978ac - odstraneni podpora pro defaultni postgresove retezce</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1524:rev-1525:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1524&oldid=prev 2026-04-09T10:57:35Z

<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 9. 4. 2026, 10:57</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l29">Řádek 29:</td> <td colspan="2" class="diff-lineno">Řádek 29:</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=b140c8d7a3f3a5de4e4cc4a0b52909aa13060d4c - [https://www.thatguyfromdelhi.com/2025/11/teaching-query-planner-to-see-inside-c.html moznost inline dotaz dynamicky dotaz z plpgsql]</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=b140c8d7a3f3a5de4e4cc4a0b52909aa13060d4c - [https://www.thatguyfromdelhi.com/2025/11/teaching-query-planner-to-see-inside-c.html moznost inline dotaz dynamicky dotaz z plpgsql]</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=e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7 - slotsync_skip_reason</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=e68b6adad96d414fdf24e072fdb1d41fb4b8f0b7 - slotsync_skip_reason</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=bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa - 64bit multixid</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa - 64bit multixid<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67c20979ce72b8c236622e5603f9775968ff501c - moznost pouzivat logickou replikaci bez restartu</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=67c20979ce72b8c236622e5603f9775968ff501c - moznost pouzivat logickou replikaci bez restartu</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=f2e4cc427951b7c46629fb7625a22f7898586f3a - MERGE PARTITIONS</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=f2e4cc427951b7c46629fb7625a22f7898586f3a - MERGE PARTITIONS</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1523:rev-1524:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1523&oldid=prev 2026-04-09T07:01:41Z

<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 9. 4. 2026, 07:01</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l75">Řádek 75:</td> <td colspan="2" class="diff-lineno">Řádek 75:</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=41d69e6dccad6ef26511a466e6484bc8807362cf - popisky v internich psql dotazech</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=41d69e6dccad6ef26511a466e6484bc8807362cf - popisky v internich psql dotazech</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=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum</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=d7965d65fc5bb2139bc51c051c11428414c65160 - prioritni vyber tabulek v autovacuum</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=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</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=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT&lt;/s&gt;</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>* &lt;s&gt;https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT&lt;/s&gt;</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=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu</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=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu</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=a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a - get pg_get_database_ddl</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=a4f774cf1c7e5c6cf2f3393f611e1df16cdb5a5a - get pg_get_database_ddl</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l88">Řádek 88:</td> <td colspan="2" class="diff-lineno">Řádek 88:</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms</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;">&lt;s&gt;</ins>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<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</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=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</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=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru</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=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1522:rev-1523:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1522&oldid=prev 2026-04-09T04:43: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 9. 4. 2026, 04:43</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l44">Řádek 44:</td> <td colspan="2" class="diff-lineno">Řádek 44:</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=cf74558feb8f41b2bc459f59ed3f991024d04893 - redukce specialnich pripadu outer joinu na antijoin</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=cf74558feb8f41b2bc459f59ed3f991024d04893 - redukce specialnich pripadu outer joinu na antijoin</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://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</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.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</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=4a1b05caa55dc14a1f936af78d8d19c843bfd8b9 - znovu povolena podpora AIX</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4a1b05caa55dc14a1f936af78d8d19c843bfd8b9 - znovu povolena podpora AIX<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* 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/</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=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/</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=ba97bf9cb7b4ca184ab669569be2633a46cfdd0c - podpora dumpu extended expr statistik</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=ba97bf9cb7b4ca184ab669569be2633a46cfdd0c - podpora dumpu extended expr statistik</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l77">Řádek 77:</td> <td colspan="2" class="diff-lineno">Řádek 77:</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=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</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=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</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=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</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=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</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=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</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=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</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=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu</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=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1521:rev-1522:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1521&oldid=prev 2026-04-09T04:24:14Z

<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 9. 4. 2026, 04:24</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Řádek 1:</td> <td colspan="2" class="diff-lineno">Řádek 1:</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=bd09f024a1bbdd7a7e2ca944595a9d4b6c90fb83 - regdatabase</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd09f024a1bbdd7a7e2ca944595a9d4b6c90fb83 - regdatabase<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0da29e4cb161f78a5ef534b3fb4467756a422e25 - podpora memoize v anti joinu (v nekterych pripadech)</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=0da29e4cb161f78a5ef534b3fb4467756a422e25 - podpora memoize v anti joinu (v nekterych pripadech)</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=fe07100e82b096d3c848cace790d4b4daf0c4131 - GetNamedDSA(), GetNamedDSHash() - user friendly alokace dynamicke sdilene pameti</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=fe07100e82b096d3c848cace790d4b4daf0c4131 - GetNamedDSA(), GetNamedDSHash() - user friendly alokace dynamicke sdilene pameti</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1520:rev-1521:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1520&oldid=prev 2026-04-09T04:02: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 9. 4. 2026, 04:02</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">Řádek 7:</td> <td colspan="2" class="diff-lineno">Řádek 7:</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=3357471cf9f5e470dfed0c7919bcf31c7efaf2b9 - přidání typu plánu do pg_stat_statements</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=3357471cf9f5e470dfed0c7919bcf31c7efaf2b9 - přidání typu plánu do pg_stat_statements</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=fd5a1a0c3e566f7fc860838084466a1c25944281 - reseni konfliktu delete/update</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=fd5a1a0c3e566f7fc860838084466a1c25944281 - reseni konfliktu delete/update</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=665c3dbba497b795c4ee46145777bc4eb89c78a1 - příprava na 64bit Datum i na 32bit platformách</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=665c3dbba497b795c4ee46145777bc4eb89c78a1 - příprava na 64bit Datum i na 32bit platformách<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</ins></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=2a600a93c7be5b0bf8cacb1af78009db12bc4857 - Datum je 8bajt všude</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2a600a93c7be5b0bf8cacb1af78009db12bc4857 - Datum je 8bajt všude<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24225ad9aafc576295e210026d8ffa9f50d61145 - vylepšená optimalizace semijoinu</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=24225ad9aafc576295e210026d8ffa9f50d61145 - vylepšená optimalizace semijoinu</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>* prechod z c99 na c11</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;">&lt;s&gt;</ins>prechod z c99 na c11<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</ins></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=63599896545c7869f7dd28cd593e8b548983d613 - generování GUC z dat souboru</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;">&lt;s&gt;</ins>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=63599896545c7869f7dd28cd593e8b548983d613 - generování GUC z dat souboru<ins style="font-weight: bold; text-decoration: none;">&lt;/s&gt;</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=faf071b553830d39fc583beabcaf56ed65259acc - random funkce pro date a timestamp</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=faf071b553830d39fc583beabcaf56ed65259acc - random funkce pro date a timestamp</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=83a56419457ec0eff2eddfed8eb3aba86bede9cc - vylepsene chybove hlaseni nenalezeni funkce</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=83a56419457ec0eff2eddfed8eb3aba86bede9cc - vylepsene chybove hlaseni nenalezeni funkce</div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1519:rev-1520:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1519&oldid=prev 2026-04-08T07:15:09Z

<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 8. 4. 2026, 07:15</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l90">Řádek 90:</td> <td colspan="2" class="diff-lineno">Řádek 90:</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms</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=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</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=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d1c01b79d4ae90e52bf9db9c05c9de17b7313e85 - automatika v nastaveni poctu IO workeru</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1518:rev-1519:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1518&oldid=prev 2026-04-08T04:22:05Z

<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 8. 4. 2026, 04:22</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l89">Řádek 89:</td> <td colspan="2" class="diff-lineno">Řádek 89:</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150% dotaz 170ms, EA19 278ms, EA18 428ms</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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;">* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=3b1117d6e2e47d86cdbd978b79434c630cb0ef52 - EXPLAIN IO</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1517:rev-1518:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1517&oldid=prev 2026-04-07T18:56:59Z

<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 7. 4. 2026, 18:56</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l88">Řádek 88:</td> <td colspan="2" class="diff-lineno">Řádek 88:</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze - explain analyze zpomaluje cca o 60% misto o 150%</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>* 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% <ins style="font-weight: bold; text-decoration: none;">dotaz 170ms, EA19 278ms, EA18 428ms</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1516:rev-1517:php=table --> </table>

PavelStehule http://postgres.cz/index.php?title=Patche_19&diff=1516&oldid=prev 2026-04-07T18:55:48Z

<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 7. 4. 2026, 18:55</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l88">Řádek 88:</td> <td colspan="2" class="diff-lineno">Řádek 88:</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=1ff3180ca0169556984ab83759477f593129794d - autovacuum muze pouzit paralelni vacuum indexu</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=c10edb102ada607eb054bc9e23690109d86849ef - persistentni hinty</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=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze</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>* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=294520c44487ecaade7a6ea8781b973f9ed03909 - použití TSC pro explain analyze <ins style="font-weight: bold; text-decoration: none;">- explain analyze zpomaluje cca o 60% misto o 150%</ins></div></td></tr> <!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1515:rev-1516:php=table --> </table>

PavelStehule