http://postgres.cz/api.php?hidebots=1&urlversion=1&days=7&limit=50&action=feedrecentchanges&feedformat=atom
PostgreSQL - Poslední změny [cs]
2026-04-05T11:36:14Z
Na tomto kanále sledujte poslední změny na PostgreSQL.
MediaWiki 1.43.3
http://postgres.cz/index.php?title=Reference_pou%C5%BEit%C3%AD_PostgreSQL_v_%C4%8CR&diff=1510&oldid=1476
Reference použití PostgreSQL v ČR
2026-04-05T04:27:33Z
<p><span class="autocomment">Státní a veřejná správa</span></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 5. 4. 2026, 04:27</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l26">Řádek 26:</td>
<td colspan="2" class="diff-lineno">Řádek 26:</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>==Státní a veřejná správa==</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>==Státní a veřejná správa==</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>* [http://www.alis.cz<del style="font-weight: bold; text-decoration: none;">/cs/produkty</del>/keo4 KEO4], aplikace-informační systém určený pro veřejnou správu, PostgreSQL 9.5, tisíce databází</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>* [http://www.alis.cz/keo4 KEO4], aplikace-informační systém určený pro veřejnou správu, PostgreSQL 9.5, tisíce databází</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>* [http://www.qcm.cz/ QCM], aplikace pro elektronizaci veřejných zakázek, elektronické tržiště a profily zadavatelů, PG 9.1 po 9.3., přes 140 Postgresových DB velikosti do 120GB, celková velikost dat v PG přes 2.5TB.</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>* [http://www.qcm.cz/ QCM], aplikace pro elektronizaci veřejných zakázek, elektronické tržiště a profily zadavatelů, PG 9.1 po 9.3., přes 140 Postgresových DB velikosti do 120GB, celková velikost dat v PG přes 2.5TB.</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>* NIS-IZS (Národní informační systém integrovaného záchraného systému), provozovatel hasičský záchraný sbor, 30 instancí 9.3 s logickou replikací vybraných tabulek</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>* NIS-IZS (Národní informační systém integrovaného záchraného systému), provozovatel hasičský záchraný sbor, 30 instancí 9.3 s logickou replikací vybraných tabulek</div></td></tr>
<!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1476:rev-1510:php=table -->
</table>
PavelStehule
http://postgres.cz/index.php?title=Patche_19&diff=1509&oldid=1502
Patche 19
2026-04-04T04:27:27Z
<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 4. 4. 2026, 04:27</td>
</tr><tr><td colspan="4" class="diff-multi" lang="cs">(Není zobrazeno 6 mezilehlých verzí od stejného uživatele.)</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 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=2da86c1ef9b5446e0e22c0b6a5846293e58d98e3 - optimalizace kontroly referencni integrity</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=8e72d914c52876525a90b28444453de8085c866f - podpora DELETE, UPDATE FOR PORTION OF</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=7f8c88c2b872cb74882ab93dcb05529dab2a10bc - vypnuti JIT</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=b7b27eb41a5cc0b45a1a9ce5c1cde5883d7bc358 - dalsi optimalizace kontroly RI (cca 3x rychlejsi)</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=f19c0eccae9680f5785b11cdc58ef571998caec9 - online vypinani zapinani kontrolnich souctu</ins></div></td></tr>
<!-- diff cache key pgwiki2-mediawiki-:diff:1.41:old-1502:rev-1509:php=table -->
</table>
PavelStehule