{"id":105303,"date":"2022-10-13T21:36:41","date_gmt":"2022-10-13T19:36:41","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-15"},"modified":"2022-10-13T21:36:41","modified_gmt":"2022-10-13T19:36:41","slug":"reliz-subd-postgresql-15","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/reliz-subd-postgresql-15","title":{"rendered":"Rr\u00ebzimi i DBMS PostgreSQL 15","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas nj\u00eb viti zhvillimi, \u00ebsht\u00eb publikuar nj\u00eb deg\u00eb e re stabile e DBMS PostgreSQL 15. p\u00ebrdit\u00ebsimet p\u00ebr k\u00ebt\u00eb deg\u00eb do t\u00eb dalin p\u00ebr pes\u00eb vjet deri n\u00eb n\u00ebntor 2027. <\/p>\n
T\u00eb rejat kryesore: <\/p>\n
\n
Shtohet mb\u00ebshtetje p\u00ebr komand\u00ebn SQL \"MERGE\", e cila \u00ebsht\u00eb e ngjashme me shprehjen \"INSERT ... ON CONFLICT\". MERGE lejon krijimin e shprehjeve SQL kushtore, duke bashkuar operacionet INSERT, UPDATE dhe DELETE n\u00eb nj\u00eb shprehje. P\u00ebr shembull, me ndihm\u00ebn e MERGE, mund t\u00eb organizoni bashkimin e dy tabelave, duke futur regjistrat e munguar dhe duke p\u00ebrdit\u00ebsuar ata ekzistues. MERGE INTO customer_account ca USING recent_transactions t ON t.customer_id = ca.customer_id WHEN MATCHED THEN UPDATE SET balance = balance + transaction_value WHEN NOT MATCHED THEN INSERT (customer_id, balance) VALUES (t.customer_id, t.transaction_value);\n
Algoritmet e renditjes s\u00eb t\u00eb dh\u00ebnave n\u00eb memorie dhe disk jan\u00eb p\u00ebrmir\u00ebsuar ndjesh\u00ebm. N\u00eb var\u00ebsi t\u00eb llojit t\u00eb t\u00eb dh\u00ebnave, n\u00eb testime v\u00ebrehet nj\u00eb rritje e shpejt\u00ebsis\u00eb s\u00eb renditjes nga 25% deri n\u00eb 400%.\n
Puna e funksioneve ndihm\u00ebse \u00ebsht\u00eb p\u00ebrshpejtuar duke p\u00ebrdorur row_number(), rank(), dense_rank() dhe count().\n
Implementuar mund\u00ebsin\u00eb p\u00ebr ekzekutimin paralel t\u00eb k\u00ebrkesave me shprehjen \"SELECT DISTINCT\".\n
N\u00eb mekanizmin e lidhjes s\u00eb tabelave t\u00eb jashtme Foreign Data Wrapper (postgres_fdw) \u00ebsht\u00eb realizuar mb\u00ebshtetje p\u00ebr angazhimet asinkrone, p\u00ebrve\u00e7 mund\u00ebsis\u00eb s\u00eb m\u00ebparshme p\u00ebr p\u00ebrpunimin asinkron t\u00eb k\u00ebrkesave ndaj server\u00ebve t\u00eb jasht\u00ebm.\n
\u00cbsht\u00eb shtuar mund\u00ebsia e aplikimit t\u00eb algoritmeve LZ4 dhe Zstandard (zstd) p\u00ebr kompresimin e regjistrave WAL t\u00eb transaksioneve, t\u00eb cilat n\u00ebn disa ngarkesa lejojn\u00eb t\u00eb rritet nj\u00ebkoh\u00ebsisht performanca dhe t\u00eb kursehet hap\u00ebsira n\u00eb disk. P\u00ebr t\u00eb shkurtuar koh\u00ebn e rikuperimit pas nj\u00eb d\u00ebshtimi, \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr nxjerrjen e parashikueshme t\u00eb faqeve q\u00eb figurojn\u00eb n\u00eb regjistrin WAL.\n