PostgreSQL - Poslední změny [cs]

PostgreSQL - Poslední změny [cs] http://postgres.cz/wiki/Speci%C3%A1ln%C3%AD:Posledn%C3%AD_zm%C4%9Bny Na tomto kanále sledujte poslední změny na PostgreSQL. cs MediaWiki 1.43.3 Sat, 29 Aug 2026 08:06:47 GMT PostgreSQL 19 (2026) http://postgres.cz/index.php?title=PostgreSQL_19_(2026)&diff=1606&oldid=1600 http://postgres.cz/index.php?title=PostgreSQL_19_(2026)&diff=1606&oldid=1600 <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 27. 8. 2026, 04:21</td> </tr><tr><td colspan="4" class="diff-multi" lang="cs">(Není zobrazena jedna mezilehlá verze od stejného uživatele.)</td></tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l112">Řádek 112:</td> <td colspan="2" class="diff-lineno">Řádek 112:</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><p>Poměrně razantně se změnila konfigurace <code>log_min_messages</code>, která udává, na které úrovni se mají chyby zapsat do systémového logu (<code>DEBUG5</code>..<code>PANIC</code>). Nově lze tuto úroveň nastavit pro každý typ procesu (<code>archiver</code>, <code>autovacuum</code>, <code>backend</code>, <code>bgworker</code>, ...) např. <code>error, walsender:debug1, autovacuum:debug1</code>.</p> </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><p>Poměrně razantně se změnila konfigurace <code>log_min_messages</code>, která udává, na které úrovni se mají chyby zapsat do systémového logu (<code>DEBUG5</code>..<code>PANIC</code>). Nově lze tuto úroveň nastavit pro každý typ procesu (<code>archiver</code>, <code>autovacuum</code>, <code>backend</code>, <code>bgworker</code>, ...) např. <code>error, walsender:debug1, autovacuum:debug1</code>.</p> </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;"><br></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;"><br></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><p>Správa partišen (partitions) byla v Postgresu základní. Díky možnosti sloučit nebo rozdělit partišny (partitions) se dostává trochu dál. Je to spíš první krok se spoustou omezení - používá se pouze jedno CPU a po celou dobu je exkluzivně zamknutá rodičovská tabulka. Ale i tak to může dost uživatelům ušetřit práci (a jejich vlastní řešení by pravděpodobně mělo stejná omezení):</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><p<ins style="font-weight: bold; text-decoration: none;">>odstraněno před vydáním<s</ins>>Správa partišen (partitions) byla v Postgresu základní. Díky možnosti sloučit nebo rozdělit partišny (partitions) se dostává trochu dál. Je to spíš první krok se spoustou omezení - používá se pouze jedno CPU a po celou dobu je exkluzivně zamknutá rodičovská tabulka. Ale i tak to může dost uživatelům ušetřit práci (a jejich vlastní řešení by pravděpodobně mělo stejná omezení):</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><pre></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><pre></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>ALTER TABLE sales_list MERGE PARTITIONS (sales_west, sales_east, sales_central) INTO sales_all;</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>ALTER TABLE sales_list MERGE PARTITIONS (sales_west, sales_east, sales_central) INTO sales_all;</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l120">Řádek 120:</td> <td colspan="2" class="diff-lineno">Řádek 120:</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> PARTITION measurement_y2006m02 FOR VALUES FROM ('2006-02-01') TO ('2006-03-01'),</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> PARTITION measurement_y2006m02 FOR VALUES FROM ('2006-02-01') TO ('2006-03-01'),</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> PARTITION measurement_y2006m03 FOR VALUES FROM ('2006-03-01') TO ('2006-04-01'));</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> PARTITION measurement_y2006m03 FOR VALUES FROM ('2006-03-01') TO ('2006-04-01'));</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></pre></p></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></pre<ins style="font-weight: bold; text-decoration: none;">></s</ins>></p></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;"><br></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;"><br></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><p>Oproti předchozím verzím lze zapínat a vypínat všechny typy omezení (nejen cizí klíče):</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><p>Oproti předchozím verzím lze zapínat a vypínat všechny typy omezení (nejen cizí klíče):</div></td></tr>  </table> Thu, 27 Aug 2026 04:21:40 GMT PavelStehule http://postgres.cz/wiki/Diskuse:PostgreSQL_19_(2026) PostgreSQL http://postgres.cz/index.php?title=PostgreSQL&diff=1604&oldid=1592 http://postgres.cz/index.php?title=PostgreSQL&diff=1604&oldid=1592 <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 17. 8. 2026, 05:08</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Řádek 5:</td> <td colspan="2" class="diff-lineno">Řádek 5:</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> caption = The '''PostgreSQL''' Logo | </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> caption = The '''PostgreSQL''' Logo | </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> developer = PostgreSQL<br>Global Development Group | </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> developer = PostgreSQL<br>Global Development Group | </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> latest_release_version = [https://www.postgresql.org/docs/release/18.<del style="font-weight: bold; text-decoration: none;">4</del>/ 18.<del style="font-weight: bold; text-decoration: none;">4</del>] | </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> latest_release_version = [https://www.postgresql.org/docs/release/18.<ins style="font-weight: bold; text-decoration: none;">6</ins>/ 18.<ins style="font-weight: bold; text-decoration: none;">6</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> latest_release_date = <del style="font-weight: bold; text-decoration: none;">14</del>. <del style="font-weight: bold; text-decoration: none;">května </del>2026 | </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> latest_release_date = <ins style="font-weight: bold; text-decoration: none;">13</ins>. <ins style="font-weight: bold; text-decoration: none;">srpna </ins>2026 | </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> operating_system = Unix, Microsoft Windows | </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> operating_system = Unix, Microsoft Windows | </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> license = PostgreSQL licence | </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> license = PostgreSQL licence | </div></td></tr>  </table> Mon, 17 Aug 2026 05:08:30 GMT PavelStehule http://postgres.cz/wiki/Diskuse:PostgreSQL Patche 20 http://postgres.cz/index.php?title=Patche_20&diff=1603&oldid=1599 http://postgres.cz/index.php?title=Patche_20&diff=1603&oldid=1599 <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 12. 8. 2026, 03:16</td> </tr><tr><td colspan="4" class="diff-multi" lang="cs">(Nejsou zobrazeny 2 mezilehlé verze od stejného uživatele.)</td></tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Řádek 3:</td> <td colspan="2" class="diff-lineno">Řádek 3:</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=3b066de6c0a1dadbd8bed107e55cae659af0598f - pg_stat_kind</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=3b066de6c0a1dadbd8bed107e55cae659af0598f - pg_stat_kind</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=86ab7f4c721d61282c058acc0b4aa0b3adf04410 - kompletni podpora JSON_TABLE - plans</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=86ab7f4c721d61282c058acc0b4aa0b3adf04410 - kompletni podpora JSON_TABLE - plans</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=commit;h=3045a25ba813b554e23c723ebe94cf504feb370c - lepší chování psql po chybě v COPY FROM stdin</ins></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=931c9701f2509160a2bed7d50129669e2cb32bf9 - vychozi komprimace WAL (pokud bude aktivni) bude zstd</ins></div></td></tr>  </table> Wed, 12 Aug 2026 03:16:02 GMT PavelStehule http://postgres.cz/wiki/Diskuse:Patche_20