PostgreSQl 13 patche: Porovnání verzí

Z PostgreSQL
Přejít na: navigace, hledání
(Není zobrazeno 9 mezilehlých verzí od stejného uživatele.)
Řádka 12: Řádka 12:
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1379fd537f9fc7941c8acff8c879ce3636dbdb77 DROP DATABASE FORCE</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1379fd537f9fc7941c8acff8c879ce3636dbdb77 DROP DATABASE FORCE</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6e3e6cc0e884a6091e1094dff29db430af08fb93 samplovani logovani pomalych dotazu</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6e3e6cc0e884a6091e1094dff29db430af08fb93 samplovani logovani pomalych dotazu</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cec2edfa7859279f36d2374770ca920c59c73dd8 logical_decoding_work_mem</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cec2edfa7859279f36d2374770ca920c59c73dd8 logical_decoding_work_mem
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f338369ca624ca6c2e4f579623274c88d325bce invisible PROMPT2</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f338369ca624ca6c2e4f579623274c88d325bce invisible PROMPT2</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c4a7a392ec8f0ff7701d84768080721ff8a7782e superuser muze menit systemove tabulky</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c4a7a392ec8f0ff7701d84768080721ff8a7782e superuser muze menit systemove tabulky</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba79cb5dc841104cf4810b5c23af4f881079dbb5 GUC log_parameters_on_error</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba79cb5dc841104cf4810b5c23af4f881079dbb5 GUC log_parameters_on_error</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=20d6225d1656102534a73d9675bc531ff0e5203b min_scale, trim_scale</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=20d6225d1656102534a73d9675bc531ff0e5203b min_scale, trim_scale</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ed10f32e37e9a16814c25e400d7826745ae3c797 pg_shmem_allocations</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ed10f32e37e9a16814c25e400d7826745ae3c797 pg_shmem_allocations
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=aaa6761876ba5b06a5c3fa914b2951ace1e31dee vylepšení vícesloupcových statistik</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=aaa6761876ba5b06a5c3fa914b2951ace1e31dee vylepšení vícesloupcových statistik</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a166d408eb0b35023c169e765f4664c3b114b52e ANALYZE</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a166d408eb0b35023c169e765f4664c3b114b52e ANALYZE
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a83586b5543b948f9e621462537a7303b113c482 jsonb_set_lax</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a83586b5543b948f9e621462537a7303b113c482 jsonb_set_lax</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=40d964ec997f64227bc0ff5e058dc4a5770a70a9 paralel vacuum - paralelni zpracovani indexu (nefunguje pro VACUUM FULL)</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=40d964ec997f64227bc0ff5e058dc4a5770a70a9 paralel vacuum - paralelni zpracovani indexu (nefunguje pro VACUUM FULL)
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13661ddd7eaec7e2809ff5c29fc14653b6161036 gcd lcm funkce</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13661ddd7eaec7e2809ff5c29fc14653b6161036 gcd lcm funkce</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=50fc694e43742ce3d04a5e9f708432cb022c5f0d trusted extensions</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=50fc694e43742ce3d04a5e9f708432cb022c5f0d trusted extensions</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c2769405ff1f4617b0d3af50760b1ee357733ef zmeny v JIT, ktere by mely umoznit lepsi optimalizaci</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c2769405ff1f4617b0d3af50760b1ee357733ef zmeny v JIT, ktere by mely umoznit lepsi optimalizaci</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e65497df8f85ab9b9084c928ff69f384ea729b24 progress report pro pg_basebackup</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e65497df8f85ab9b9084c928ff69f384ea729b24 progress report pro pg_basebackup
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d861bbb702f8aa05c2a4e3f1650e7e8df8c8c27 deduplikace klicu v indexu</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d861bbb702f8aa05c2a4e3f1650e7e8df8c8c27 deduplikace klicu v indexu</s>
* <s>https://rjuju.github.io/postgresql/2020/02/06/new-in-pg13-leader_pid.html - leader pid</s>
+
* https://rjuju.github.io/postgresql/2020/02/06/new-in-pg13-leader_pid.html - leader pid
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dcdbb5a5db09064ac08ff3971c5031281ef2e545 %x do promptu - v transakci nebo ne</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dcdbb5a5db09064ac08ff3971c5031281ef2e545 %x do promptu - v transakci nebo ne</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=70a7732007bc4689f4c7a44e738eb2d892dac1e3 odstraneni podpory CREATE EXTENSION FROM UNPACKAGED</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=70a7732007bc4689f4c7a44e738eb2d892dac1e3 odstraneni podpory CREATE EXTENSION FROM UNPACKAGED</s>
Řádka 34: Řádka 34:
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a6525588b7c21fd8539e9a43ec9c5c245ed1cc91 escape lze použít i pro jiná kodování než je UTF8</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a6525588b7c21fd8539e9a43ec9c5c245ed1cc91 escape lze použít i pro jiná kodování než je UTF8</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83daa7e331e0718bb254ab685f2ed95df423554 vicesloupcove statistiky pro arrayin</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83daa7e331e0718bb254ab685f2ed95df423554 vicesloupcove statistiky pro arrayin</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc34b0d9de27ab5ac2887da00b3892bdabd89e45 maintenance_io_concurrency</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc34b0d9de27ab5ac2887da00b3892bdabd89e45 maintenance_io_concurrency
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ccaa3569f58796868303629bc2d63ddddb599b38 podpora vícesloupcových statistik pro operátor OR</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ccaa3569f58796868303629bc2d63ddddb599b38 podpora vícesloupcových statistik pro operátor OR</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=487e9861d0cf83e9100ad0d0369147db3ef4ea73 before triggery pro partitiovane tabulky</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=487e9861d0cf83e9100ad0d0369147db3ef4ea73 before triggery pro partitiovane tabulky
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1f39bce021540fde00990af55b4432c55ef4b3c7 hashagg s limitem work_mem</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1f39bce021540fde00990af55b4432c55ef4b3c7 hashagg s limitem work_mem</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 anycompatible polymorfni typ</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 anycompatible polymorfni typ</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=496ee647ecd2917369ffcf1eaa0b2cdca07c8730 prefer standby pomotion over pause</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=496ee647ecd2917369ffcf1eaa0b2cdca07c8730 prefer standby pomotion over pause
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f9eb31320948b968e5f744b73032405e1f25225 pg_dump může dumpovat data z cizích tabulek</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f9eb31320948b968e5f744b73032405e1f25225 pg_dump může dumpovat data z cizích tabulek
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f59f6b9c0376173a072e4fb7de1edd6a26e6b52 redukce rezie plan cache jednoduchych vyrazu v plpgsql</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f59f6b9c0376173a072e4fb7de1edd6a26e6b52 redukce rezie plan cache jednoduchych vyrazu v plpgsql</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b07642dbcd8d5de05f0ee1dbb72dd6760dd30436 INSERT trigger autovacuum</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b07642dbcd8d5de05f0ee1dbb72dd6760dd30436 INSERT trigger autovacuum
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4083f445c0cbda2eacb6b17297f9d555397e5eaa rychlejsi vypocet sqrt a ln</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4083f445c0cbda2eacb6b17297f9d555397e5eaa rychlejsi vypocet sqrt a ln</s>
 
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a7e8ece41cf7a96d8a9c4c037cdfef304d950831 vylepšení pg_rewind
 
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a7e8ece41cf7a96d8a9c4c037cdfef304d950831 vylepšení pg_rewind
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2991ac5fc9b3904ca4582be6d323497d7c3d17c9 normalizace UNICODE znaku - select normalize(U&'\0065\0301') = 'é';</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2991ac5fc9b3904ca4582be6d323497d7c3d17c9 normalizace UNICODE znaku - select normalize(U&'\0065\0301') = 'é';</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=17e03282241c6ac58a714eb0c3b6a8018cf6167a pg_stat_statements může obsahovat planning time</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=17e03282241c6ac58a714eb0c3b6a8018cf6167a pg_stat_statements může obsahovat planning time</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28cac71bd368788d1ab22f048eef211641fb1283 pg_stat_slru</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28cac71bd368788d1ab22f048eef211641fb1283 pg_stat_slru
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0b34e7d307e6a142ee94800e6d5f3e73449eeffd nastaveni maximalni velikosti logovanych parametru</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0b34e7d307e6a142ee94800e6d5f3e73449eeffd nastaveni maximalni velikosti logovanych parametru</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ce77abe63cfc85fb0bc236deb2cc34ae35cb5324 EXPLAIN muze zobrazit velikost nactenych dat (buffers) v planning time</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ce77abe63cfc85fb0bc236deb2cc34ae35cb5324 EXPLAIN muze zobrazit velikost nactenych dat (buffers) v planning time</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d8c9c1210c44b36ec2efcb223a1dfbe897a3661 backup manifest & pg_validate backup</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d8c9c1210c44b36ec2efcb223a1dfbe897a3661 backup manifest & pg_validate backup
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=df3b181499b40523bd6244a4e5eb554acb9020ce infrastruktura pro monitoring zapisu do WAL</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=df3b181499b40523bd6244a4e5eb554acb9020ce infrastruktura pro monitoring zapisu do WAL</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6b466bf5f2bea0c89fab54eef696bcfc7ecdafd7 pg_stat_statements muze monitorovat zapisy do WAL</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6b466bf5f2bea0c89fab54eef696bcfc7ecdafd7 pg_stat_statements muze monitorovat zapisy do WAL</s>
Řádka 56: Řádka 56:
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2d8a229bc58a2014dce1c7a4fcdb6c5ab9fb8da incremental sort</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2d8a229bc58a2014dce1c7a4fcdb6c5ab9fb8da incremental sort</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=357889eb17bb9c9336c4f324ceb1651da616fe57 FETCH FIRST with ties</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=357889eb17bb9c9336c4f324ceb1651da616fe57 FETCH FIRST with ties</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c6550776394e25c1620bc8258427c8f1d448080d Invalidace slotu pokud drží víc než nastavený limit</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c6550776394e25c1620bc8258427c8f1d448080d Invalidace slotu pokud drží víc než nastavený limit
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c8434d64ce03c32e0029417a82ae937f2055268f častější použití partitionwise joinu</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c8434d64ce03c32e0029417a82ae937f2055268f častější použití partitionwise joinu
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=981643dcdb70b6ce70d8a08417f71f465f236cb5 partitionwise join pro FULL JOIN</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=981643dcdb70b6ce70d8a08417f71f465f236cb5 partitionwise join pro FULL JOIN
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=75848bc74411130ede23995d0ab1aefb12c4c4b0 redukce režie získání snapshotu</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=75848bc74411130ede23995d0ab1aefb12c4c4b0 redukce režie získání snapshotu</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b63c293bcbd7439f883cd4cf748f6755df0fbb3c parametrizace nastavení zobrazení příkazů \g*</s>
 
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b63c293bcbd7439f883cd4cf748f6755df0fbb3c parametrizace nastavení zobrazení příkazů \g*</s>
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=83fd4532a72179c370e318075a10e0e2aa832024 zverejneni partitions pres predka</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=83fd4532a72179c370e318075a10e0e2aa832024 zverejneni partitions pres predka
* <s>https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dbc60c5593f26dc777a3be032bff4fb4eab1ddd1 pg_validatebackup se prjmenuje na pg_verifybackup</s>
+
* https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dbc60c5593f26dc777a3be032bff4fb4eab1ddd1 pg_validatebackup se prjmenuje na pg_verifybackup

Verze z 14. 4. 2020, 14:45