PostgreSQl 13 patche

• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=02e95a5049f7933cbde1dacf401604ea3fc02aa5 \warn
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=7266d0997dd2a0632da38a594c78e25ff21df67e nahrada volani funkce vysledkem v klauzuli FROM
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d06215d03b50c264a0f31e335b895ee1b6753e68 ALTER STATISTICS xx SET STATISTICS
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d589f94460c24d9b7ac21887d031818d6e3f354d format pro desetiny sec FF1..FF6
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b64b857f50fb51da1588c54a56f8fc1c0d491058 SSSSS hodina, minuta se uvadi ve vterinach k pulnoci
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5adafaf176d09ba5ea11ae128416fc5211469bc0 pg_rewind provede recovery
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=927474ce1a2498ddb617c6113a88ca61fbba161d volba -R pro pg_rewind
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e788bd924c19e296bd34316e30e3ba1b68354e64 hooks session_start, session_end
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5dd7fc1519461548eebf26c33eac6878ea3e8788 transparentni pocitani alokovane pameti
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=26aaf97b683d6258c098859e6b1268e1f5da242f moznost pouziti string info na clientu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=71a8a4f6e36547bb060dbcc961ea9b57420f7190 automaticke zobrazeni backtrace na assert
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1379fd537f9fc7941c8acff8c879ce3636dbdb77 DROP DATABASE FORCE
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6e3e6cc0e884a6091e1094dff29db430af08fb93 samplovani logovani pomalych dotazu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cec2edfa7859279f36d2374770ca920c59c73dd8 logical_decoding_work_mem
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=7f338369ca624ca6c2e4f579623274c88d325bce invisible PROMPT2
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c4a7a392ec8f0ff7701d84768080721ff8a7782e superuser muze menit systemove tabulky
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ba79cb5dc841104cf4810b5c23af4f881079dbb5 GUC log_parameters_on_error
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=20d6225d1656102534a73d9675bc531ff0e5203b min_scale, trim_scale
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ed10f32e37e9a16814c25e400d7826745ae3c797 pg_shmem_allocations
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=aaa6761876ba5b06a5c3fa914b2951ace1e31dee vylepšení vícesloupcových statistik
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a166d408eb0b35023c169e765f4664c3b114b52e ANALYZE
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a83586b5543b948f9e621462537a7303b113c482 jsonb_set_lax
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=40d964ec997f64227bc0ff5e058dc4a5770a70a9 paralel vacuum - paralelni zpracovani indexu (nefunguje pro VACUUM FULL)
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=13661ddd7eaec7e2809ff5c29fc14653b6161036 gcd lcm funkce
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=50fc694e43742ce3d04a5e9f708432cb022c5f0d trusted extensions
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8c2769405ff1f4617b0d3af50760b1ee357733ef zmeny v JIT, ktere by mely umoznit lepsi optimalizaci
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e65497df8f85ab9b9084c928ff69f384ea729b24 progress report pro pg_basebackup
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d861bbb702f8aa05c2a4e3f1650e7e8df8c8c27 deduplikace klicu v indexu
• https://rjuju.github.io/postgresql/2020/02/06/new-in-pg13-leader_pid.html - leader pid
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dcdbb5a5db09064ac08ff3971c5031281ef2e545 %x do promptu - v transakci nebo ne
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=70a7732007bc4689f4c7a44e738eb2d892dac1e3 odstraneni podpory CREATE EXTENSION FROM UNPACKAGED
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2742c45080077ed3b08b810bb96341499b86d530 redukce kroku potřebných k final agg
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d67755049388526cd8673aa826dc794b97345eb3 to_date, to_timestamp rozpozna locales jmena dnu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a6525588b7c21fd8539e9a43ec9c5c245ed1cc91 escape lze použít i pro jiná kodování než je UTF8
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e83daa7e331e0718bb254ab685f2ed95df423554 vicesloupcove statistiky pro arrayin
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=fc34b0d9de27ab5ac2887da00b3892bdabd89e45 maintenance_io_concurrency
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ccaa3569f58796868303629bc2d63ddddb599b38 podpora vícesloupcových statistik pro operátor OR
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=487e9861d0cf83e9100ad0d0369147db3ef4ea73 before triggery pro partitiovane tabulky
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1f39bce021540fde00990af55b4432c55ef4b3c7 hashagg s limitem work_mem
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=24e2885ee304cb6a94fdfc25a1a108344ed9f4f7 anycompatible polymorfni typ
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=496ee647ecd2917369ffcf1eaa0b2cdca07c8730 prefer standby pomotion over pause
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=2f9eb31320948b968e5f744b73032405e1f25225 pg_dump může dumpovat data z cizích tabulek
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8f59f6b9c0376173a072e4fb7de1edd6a26e6b52 redukce rezie plan cache jednoduchych vyrazu v plpgsql
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b07642dbcd8d5de05f0ee1dbb72dd6760dd30436 INSERT trigger autovacuum
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=4083f445c0cbda2eacb6b17297f9d555397e5eaa rychlejsi vypocet sqrt a ln
• 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=2991ac5fc9b3904ca4582be6d323497d7c3d17c9 normalizace UNICODE znaku - select normalize(U&'\0065\0301') = 'é';
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=17e03282241c6ac58a714eb0c3b6a8018cf6167a pg_stat_statements může obsahovat planning time
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=28cac71bd368788d1ab22f048eef211641fb1283 pg_stat_slru
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0b34e7d307e6a142ee94800e6d5f3e73449eeffd nastaveni maximalni velikosti logovanych parametru
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ce77abe63cfc85fb0bc236deb2cc34ae35cb5324 EXPLAIN muze zobrazit velikost nactenych dat (buffers) v planning time
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=0d8c9c1210c44b36ec2efcb223a1dfbe897a3661 backup manifest & pg_validate backup
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=df3b181499b40523bd6244a4e5eb554acb9020ce infrastruktura pro monitoring zapisu do WAL
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=6b466bf5f2bea0c89fab54eef696bcfc7ecdafd7 pg_stat_statements muze monitorovat zapisy do WAL
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=33e05f89c53e5a1533d624046bb6fb0da7bb7141 EXPLAIN muze zobrazit zapisy do WAL
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2d8a229bc58a2014dce1c7a4fcdb6c5ab9fb8da incremental sort
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=357889eb17bb9c9336c4f324ceb1651da616fe57 FETCH FIRST with ties
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c6550776394e25c1620bc8258427c8f1d448080d Invalidace slotu pokud drží víc než nastavený limit
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c8434d64ce03c32e0029417a82ae937f2055268f častější použití partitionwise joinu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=981643dcdb70b6ce70d8a08417f71f465f236cb5 partitionwise join pro FULL JOIN
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=75848bc74411130ede23995d0ab1aefb12c4c4b0 redukce režie získání snapshotu
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b63c293bcbd7439f883cd4cf748f6755df0fbb3c parametrizace nastavení zobrazení příkazů \g*
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=83fd4532a72179c370e318075a10e0e2aa832024 zverejneni partitions pres predka
• https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dbc60c5593f26dc777a3be032bff4fb4eab1ddd1 pg_validatebackup se prjmenuje na pg_verifybackup