{"id":39855,"date":"2026-11-21T14:00:00","date_gmt":"2026-11-21T10:30:00","guid":{"rendered":"https:\/\/webdade.com\/blog\/?p=39855"},"modified":"2026-11-19T13:24:54","modified_gmt":"2026-11-19T09:54:54","slug":"install-postgresql-vps-memory","status":"publish","type":"post","link":"https:\/\/webdade.com\/blog\/install-postgresql-vps-memory","title":{"rendered":"\u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u0648 \u062a\u0646\u0638\u06cc\u0645 \u0645\u0635\u0631\u0641 \u062d\u0627\u0641\u0638\u0647"},"content":{"rendered":"<style>.wd-h2{font-size:30px;line-height:1.4;font-weight:700;color:var(--wp--preset--color--palette-color-2,var(--theme-palette-color-2,#00509d));margin:36px 0 22px!important;padding-bottom:12px;position:relative}.wd-h2::after{content:'';position:absolute;right:0;bottom:0;width:60px;height:3px;border-radius:3px;background:var(--wp--preset--color--palette-color-1,var(--theme-palette-color-1,#106abf))}.wd-h3{font-size:22px;line-height:1.4;font-weight:700;color:var(--wp--preset--color--palette-color-1,var(--theme-palette-color-1,#106abf));margin:26px 0 10px!important}p.wd-p{font-size:17px;line-height:2;margin:0 0 16px!important;color:var(--theme-text-color)}.wd-box{margin:10px 0!important;padding:20px 22px!important;border-right:5px solid var(--wp--preset--color--palette-color-1,var(--theme-palette-color-1,#106abf));border-radius:12px;background-color:#106abf1f;box-sizing:border-box}.wd-box.wd-warn{border-right-color:#b9770e;background-color:#c87f0026}.wd-box>*{margin-top:0!important;margin-bottom:0!important}p.wd-boxt{font-size:17px;line-height:1.6;font-weight:700;color:var(--wp--preset--color--palette-color-2,var(--theme-palette-color-2,#00509d));margin:0 0 4px!important}.wd-warn p.wd-boxt{color:#b9770e}p.wd-boxp{font-size:15px;line-height:1.9;margin:0!important;color:var(--theme-text-color)}p.wd-boxp a{font-weight:600}.wd-btns{justify-content:center;margin:14px 0 4px!important}.wd-btn .wp-block-button__link{background-color:var(--wp--preset--color--palette-color-1,var(--theme-palette-color-1,#106abf));color:#fff;border-radius:999px;padding:14px 38px;font-weight:700;font-size:16px;line-height:1.5;text-decoration:none}.wd-btn .wp-block-button__link:hover{background-color:var(--wp--preset--color--palette-color-2,var(--theme-palette-color-2,#00509d));color:#fff}.wd-img{margin:10px 0!important}.wd-img img{border-radius:12px;max-width:100%;height:auto}.wd-table{margin:10px 0!important}.wd-list{margin:0 0 16px!important;padding-right:22px}.wd-list li{font-size:17px;line-height:1.9;margin-bottom:6px}.wd-code{margin:10px 0!important;direction:ltr;text-align:left}.wd-p code,.wd-boxp code,.wd-list code,.wd-table code,.gs-accordion-item__text code{font-size:.82em;line-height:1.6;padding:1px 6px;border-radius:4px;background-color:#8881;direction:ltr;unicode-bidi:isolate;white-space:normal;word-break:break-word}.wd-table td,.wd-table th{font-size:15px;line-height:1.8}#gspb_container-id-gsbp-821f001{display:none}@media (max-width:689.98px){.wd-h2{font-size:24px}.wd-h3{font-size:19px}p.wd-p,.wd-list li{font-size:16px;line-height:1.9}.wd-box{padding:16px!important}}.gspb_text-id-gsbp-821f004,.gspb_text-id-gsbp-821f006,.gspb_text-id-gsbp-821f008,.gspb_text-id-gsbp-821f010,.gspb_text-id-gsbp-821f012,.gspb_text-id-gsbp-821f014,.gspb_text-id-gsbp-821f016{font-size:16px;line-height:1.9;color:var(--theme-text-color)}#gspb_text-id-gsbp-821f004,#gspb_text-id-gsbp-821f006,#gspb_text-id-gsbp-821f008,#gspb_text-id-gsbp-821f010,#gspb_text-id-gsbp-821f012,#gspb_text-id-gsbp-821f014,#gspb_text-id-gsbp-821f016{margin:0}#gspb_accordion-id-gsbp-821f002{margin-top:10px;margin-bottom:10px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item{margin-bottom:10px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{overflow:hidden}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item:not(.gsopen)>.gs-accordion-item__content{opacity:0;max-height:0}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item.gsopen>.gs-accordion-item__content{opacity:1;max-height:5000px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title>.gs-accordion-item__heading{outline:0;text-decoration:none;margin:0!important;padding:0!important;flex-grow:1;font-size:16px;line-height:1.6;font-weight:700}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{z-index:1;margin:0;cursor:pointer;transition:all .3s ease-in-out;position:relative;display:flex;justify-content:space-between;align-items:center;flex-wrap:nowrap;text-align:right;flex-direction:row-reverse;padding:15px 20px;font-size:16px;border:1px solid var(--wp--preset--color--border,#00000012);background-color:var(--wp--preset--color--palette-color-5,var(--theme-palette-color-5,#e8ebed))}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{z-index:0;position:relative;max-height:0;will-change:max-height;transition:all .25s ease-out;background-color:var(--wp--preset--color--palette-color-7,var(--theme-palette-color-7,#fbfbfc));border:1px solid var(--wp--preset--color--palette-color-5,var(--theme-palette-color-5,#e8ebed));border-top-color:#00000000}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content>.gs-accordion-item__text{padding:15px 20px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title span.iconfortoggle{margin-left:15px;display:inline-block;height:14px;width:14px;position:relative;flex:0 0 14px}#gspb_accordion-id-gsbp-821f002 .iconfortoggle .gs-iconbefore,#gspb_accordion-id-gsbp-821f002 .iconfortoggle .gs-iconafter{position:absolute;background-color:currentColor;transition:transform .25s ease-out}#gspb_accordion-id-gsbp-821f002 .iconfortoggle .gs-iconbefore{top:0;left:50%;width:2px;margin-left:-1px;height:100%}#gspb_accordion-id-gsbp-821f002 .iconfortoggle .gs-iconafter{top:50%;left:0;width:100%;height:2px;margin-top:-1px}#gspb_accordion-id-gsbp-821f002 .gsopen .iconfortoggle .gs-iconbefore{transform:rotate(90deg)}#gspb_accordion-id-gsbp-821f002 .gsopen .iconfortoggle .gs-iconafter{transform:rotate(180deg)}<\/style>\n<div class=\"wp-block-greenshift-blocks-container gspb_container gspb_container-gsbp-821f001\" id=\"gspb_container-id-gsbp-821f001\"><\/div>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0642\u062f\u0645 \u0627\u0648\u0644 \u0631\u0627 \u0628\u0631\u062f\u0627\u0634\u062a\u0647\u200c\u0627\u06cc\u062f: \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0628\u0627 \u062f\u0648 \u062f\u0633\u062a\u0648\u0631 apt \u062a\u0645\u0627\u0645 \u0634\u062f\u0647 \u0648 psql \u062c\u0648\u0627\u0628 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0627\u0645\u0627 \u0639\u062f\u062f\u0647\u0627\u06cc \u062d\u0627\u0641\u0638\u0647 \u0647\u0646\u0648\u0632 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636\u200c\u0627\u0646\u062f. \u0646\u0633\u062e\u0647 16 \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u0628\u0627 shared_buffers \u0628\u0631\u0627\u0628\u0631 128MB \u0648 work_mem \u0628\u0631\u0627\u0628\u0631 4MB \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0686\u0647 \u0633\u0631\u0648\u0631\u062a\u0627\u0646 2GB \u0631\u0645 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u0686\u0647 16GB.<\/p>\n\n\n\n<ul class=\"wp-block-list wd-list\">\n<li>\u2705 \u0645\u0642\u062f\u0627\u0631 shared_buffers: \u0634\u0631\u0648\u0639 \u0627\u0632 \u06f2\u06f5 \u062f\u0631\u0635\u062f \u0631\u0645 \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc.<\/li>\n\n\n\n<li>\u2705 \u0645\u0642\u062f\u0627\u0631 work_mem: \u0633\u0642\u0641 \u0647\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a sort \u06cc\u0627 hash\u061b \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0686\u0646\u062f \u0633\u0647\u0645 \u0628\u06af\u06cc\u0631\u062f.<\/li>\n\n\n\n<li>\u2705 \u0645\u0642\u062f\u0627\u0631 effective_cache_size: \u0641\u0642\u0637 \u062a\u062e\u0645\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632 \u06a9\u0648\u0626\u0631\u06cc.<\/li>\n\n\n\n<li>\u2705 \u0645\u0642\u062f\u0627\u0631 maintenance_work_mem: \u062d\u0627\u0641\u0638\u0647 VACUUM \u0648 CREATE INDEX.<\/li>\n\n\n\n<li>\u2705 \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a: \u0627\u0648\u0644 pg_hba.conf\u060c \u0628\u0639\u062f listen_addresses.<\/li>\n\n\n\n<li>\u2705 \u0628\u06a9\u0627\u067e: <code>pg_dump -Fc<\/code> \u0648 \u06cc\u06a9 \u0628\u0627\u0631 \u062a\u0645\u0631\u06cc\u0646 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc.<\/li>\n\n\n\n<li>\u2705 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f: \u0631\u0648\u0634\u0646 \u06a9\u0631\u062f\u0646 log_min_duration_statement.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-group wd-box wd-info is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\ud83d\udca1 \u0633\u0647 \u062d\u0627\u0641\u0638\u0647 \u0628\u0627 \u0627\u0633\u0645\u200c\u0647\u0627\u06cc \u0634\u0628\u06cc\u0647 \u0648 \u0631\u0641\u062a\u0627\u0631 \u0645\u062a\u0641\u0627\u0648\u062a<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u067e\u0627\u0631\u0627\u0645\u062a\u0631 shared_buffers \u062d\u0627\u0641\u0638\u0647 \u0645\u0634\u062a\u0631\u06a9 \u0647\u0645\u0647 \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u0633\u062a \u0648 \u0641\u0642\u0637 \u0628\u0627 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0639\u0648\u0636 \u0645\u06cc\u200c\u0634\u0648\u062f. <br>\u067e\u0627\u0631\u0627\u0645\u062a\u0631 work_mem \u0628\u0631\u0627\u06cc \u0647\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a sort \u06cc\u0627 hash \u062c\u062f\u0627 \u062d\u0633\u0627\u0628 \u0645\u06cc\u200c\u0634\u0648\u062f. <br>\u067e\u0627\u0631\u0627\u0645\u062a\u0631 effective_cache_size \u0647\u06cc\u0686 \u062d\u0627\u0641\u0638\u0647\u200c\u0627\u06cc \u0646\u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n<\/div>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0647\u062f\u0641\u060c \u062f\u0648 \u0639\u062f\u062f \u0648 \u06cc\u06a9 \u0641\u0647\u0631\u0633\u062a \u0627\u0633\u062a: shared_buffers \u0648 work_mem \u0633\u0631\u0648\u0631 \u062e\u0648\u062f\u062a\u0627\u0646 \u0648 IP\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062d\u0642 \u0627\u062a\u0635\u0627\u0644 \u062f\u0627\u0631\u0646\u062f\u060c \u0647\u0631 \u06a9\u062f\u0627\u0645 \u0628\u0627 \u062f\u0644\u06cc\u0644. \u067e\u06cc\u0634\u200c\u0641\u0631\u0636\u200c\u0647\u0627 \u0648 \u062e\u0631\u0648\u062c\u06cc\u200c\u0647\u0627\u06cc \u0627\u06cc\u0646 \u0645\u062a\u0646 \u0647\u0645\u0647 \u0627\u0632 \u06cc\u06a9 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u062a\u0627\u0632\u0647 \u0627\u0633\u062a.<\/p>\n\n\n\n<div class=\"wp-block-group wd-box wd-toc is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\ud83d\udccc \u0686\u0647\u0627\u0631 \u067e\u0631\u0633\u0634 \u0628\u0639\u062f \u0627\u0632 \u0646\u0635\u0628<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u25c0\ufe0f <a href=\"#after-install\">\u0627\u0648\u0644\u06cc\u0646 \u0628\u0631\u0631\u0633\u06cc\u200c\u0647\u0627 \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/a><br>\u25c0\ufe0f <a href=\"#memory\">\u0633\u0647\u0645 shared_buffers \u0648 work_mem \u0627\u0632 \u0631\u0645 \u0686\u0642\u062f\u0631 \u0628\u0627\u0634\u062f\u061f<\/a><br>\u25c0\ufe0f <a href=\"#remote-access\">\u0686\u0637\u0648\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u062c\u0644\u0648\u06cc \u0647\u0645\u0647 \u0646\u06af\u0630\u0627\u0631\u06cc\u0645\u061f<\/a><br>\u25c0\ufe0f <a href=\"#backup-slow\">\u0628\u06a9\u0627\u067e \u0628\u0627 pg_dump \u0648 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0627\u0632 \u06a9\u062c\u0627 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/a><\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div class=\"wp-block-greenshift-blocks-image gspb_image gspb_image-id-gsbp-74cc63a\" id=\"gspb_image-id-gsbp-74cc63a\"><img decoding=\"async\" src=\"https:\/\/webdade.com\/blog\/wp-content\/uploads\/2026\/11\/Server-Memory-Allocation-Flow-1.webp\" data-src=\"\" alt=\"\u0646\u0635\u0628 postgresql\u060c \u062a\u0642\u0633\u06cc\u0645 \u0631\u0645 \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u0628\u06cc\u0646 \u062d\u0627\u0641\u0638\u0647 \u0645\u0634\u062a\u0631\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u060c \u062d\u0627\u0641\u0638\u0647 \u06a9\u0627\u0631\u06cc \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627 \u0648 \u06a9\u0634 \u0633\u06cc\u0633\u062a\u0645\u200c\u0639\u0627\u0645\u0644\" loading=\"lazy\" width=\"1774\" height=\"887\" title=\"\u062a\u0642\u0633\u06cc\u0645 \u0631\u0645 \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u0628\u06cc\u0646 \u062d\u0627\u0641\u0638\u0647 \u0645\u0634\u062a\u0631\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u060c \u062d\u0627\u0641\u0638\u0647 \u06a9\u0627\u0631\u06cc \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627 \u0648 \u06a9\u0634 \u0633\u06cc\u0633\u062a\u0645\u200c\u0639\u0627\u0645\u0644\"\/><\/div>\n\n\n\n<h2 id=\"after-install\" class=\"wp-block-heading wd-h2\">\u0628\u0639\u062f \u0627\u0632 \u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u060c \u0627\u0648\u0644 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0628\u0627\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u0645\u061f<\/h2>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u067e\u0627\u0633\u062e \u06a9\u0648\u062a\u0627\u0647:<\/strong> \u0646\u0633\u062e\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0648\u0627\u0642\u0639\u0627\u064b \u0646\u0635\u0628 \u0634\u062f\u0647 \u0648 \u0645\u0642\u062f\u0627\u0631 \u0641\u0639\u0644\u06cc \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u062d\u0627\u0641\u0638\u0647 \u0648 \u0627\u062a\u0635\u0627\u0644\u061b \u0628\u062f\u0648\u0646 \u0627\u06cc\u0646 \u062f\u0648\u060c \u0647\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u062d\u062f\u0633 \u0627\u0633\u062a.<\/p>\n\n\n\n<h3 id=\"\u0646\u0633\u062e\u0647-\u0648-\u062e\u0648\u0634\u0647-\u0627\u06cc-\u06a9\u0647-\u0627\u0648\u0628\u0648\u0646\u062a\u0648-\u0633\u0627\u062e\u062a\u0647-\u0627\u0633\u062a\" class=\"wp-block-heading wd-h3\">\u0646\u0633\u062e\u0647 \u0648 \u062e\u0648\u0634\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u0633\u0627\u062e\u062a\u0647 \u0627\u0633\u062a<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0631 \u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u0628\u0633\u062a\u0647 postgresql \u0628\u0647 postgresql-16 \u0648\u0627\u0628\u0633\u062a\u0647 \u0627\u0633\u062a. \u062f\u0633\u062a\u0648\u0631 \u0627\u0648\u0644 \u0641\u0647\u0631\u0633\u062a \u0628\u0633\u062a\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u0627\u0632\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u062f\u0648\u0645\u06cc \u0633\u0631\u0648\u0631 \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061b \u0646\u0633\u062e\u0647 \u0646\u0635\u0628\u200c\u0634\u062f\u0647 16.15 \u0628\u0648\u062f\u060c \u0628\u0627 \u062e\u0648\u0634\u0647 main \u0631\u0648\u06cc \u067e\u0648\u0631\u062a 5432.<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo apt update\nsudo apt install postgresql\npg_lsclusters<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062e\u0631\u0648\u062c\u06cc pg_lsclusters \u0648\u0636\u0639\u06cc\u062a \u062e\u0648\u0634\u0647 \u0648 \u0645\u0633\u06cc\u0631 \u0644\u0627\u06af \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f: \/var\/log\/postgresql\/postgresql-16-main.log\u060c \u06a9\u0647 \u0628\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0644\u0627\u0632\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<h3 id=\"\u0641\u0627\u06cc\u0644-\u0647\u0627\u06cc-\u062a\u0646\u0638\u06cc\u0645\u0627\u062a-\u06a9\u062c\u0627-\u0647\u0633\u062a\u0646\u062f-\u0648-\u0627\u0644\u0627\u0646-\u0686\u0647-\u0645\u06cc-\u06af\u0648\u06cc\u0646\u062f\" class=\"wp-block-heading wd-h3\">\u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u06a9\u062c\u0627 \u0647\u0633\u062a\u0646\u062f \u0648 \u0627\u0644\u0627\u0646 \u0686\u0647 \u0645\u06cc\u200c\u06af\u0648\u06cc\u0646\u062f\u061f<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0627\u0648\u0628\u0648\u0646\u062a\u0648 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0631\u0627 \u062c\u062f\u0627 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \/etc\/postgresql\/16\/main\/ \u0646\u06af\u0647 \u0645\u06cc\u200c\u062f\u0627\u0631\u062f. \u0645\u0633\u06cc\u0631 \u0648 \u0645\u0642\u062f\u0627\u0631\u0647\u0627 \u0631\u0627 \u0627\u0632 \u062e\u0648\u062f \u0633\u0631\u0648\u0631 \u0628\u067e\u0631\u0633\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres psql\nSHOW config_file;\nSELECT name, setting, unit, context FROM pg_settings\nWHERE name IN ('shared_buffers', 'work_mem', 'maintenance_work_mem',\n               'effective_cache_size', 'listen_addresses', 'max_connections');<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0633\u062a\u0648\u0646 context \u0627\u0632 \u062e\u0648\u062f \u0639\u062f\u062f \u0645\u0647\u0645\u200c\u062a\u0631 \u0627\u0633\u062a: postmaster \u06cc\u0639\u0646\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0641\u0642\u0637 \u0628\u0627 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0627\u0639\u0645\u0627\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f (shared_buffers \u0648 listen_addresses) \u0648 user \u06cc\u0639\u0646\u06cc \u0647\u0631 \u062c\u0644\u0633\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627 SET \u0639\u0648\u0636\u0634 \u06a9\u0646\u062f (work_mem). \u0628\u0631\u0627\u06cc \u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u06a9\u0627\u0645\u0644\u060c <a href=\"https:\/\/webdade.com\/blog\/vscode-remote-ssh-server\">\u0648\u06cc\u0631\u0627\u06cc\u0634 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u0633\u0631\u0648\u0631 \u0628\u0627 vs code remote ssh<\/a> \u062c\u0627\u06cc nano \u0631\u0627 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n\n\n\n<h3 id=\"\u06a9\u0627\u0631\u0628\u0631-\u0648-\u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u06cc-\u06a9\u0647-\u0645\u062b\u0627\u0644-\u0647\u0627\u06cc-\u0628\u0639\u062f\u06cc-\u0644\u0627\u0632\u0645-\u062f\u0627\u0631\u0646\u062f\" class=\"wp-block-heading wd-h3\">\u06a9\u0627\u0631\u0628\u0631 \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u06cc \u06a9\u0647 \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u0628\u0639\u062f\u06cc \u0644\u0627\u0632\u0645 \u062f\u0627\u0631\u0646\u062f<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u0628\u0639\u062f\u06cc \u06a9\u0627\u0631\u0628\u0631 appuser \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 shop \u0631\u0627 \u0644\u0627\u0632\u0645 \u062f\u0627\u0631\u0646\u062f\u061b \u0628\u0633\u0627\u0632\u06cc\u062f\u0634\u0627\u0646 \u06cc\u0627 \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u062e\u0648\u062f\u062a\u0627\u0646 \u0631\u0627 \u0628\u06af\u0630\u0627\u0631\u06cc\u062f. \u0628\u0627 \u06af\u0632\u06cc\u0646\u0647 &#8211;pwprompt\u060c createuser \u0631\u0645\u0632 \u0631\u0627 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u062f \u0648 \u0686\u06cc\u0632\u06cc \u062f\u0631 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u0634\u0644 \u0646\u0645\u06cc\u200c\u0645\u0627\u0646\u062f\u061b \u06cc\u06a9 \u0631\u0645\u0632 \u0642\u0648\u06cc \u062a\u0627\u0632\u0647 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres createuser --pwprompt appuser\nsudo -u postgres createdb -O appuser shop<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group wd-box wd-warn is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\u26a0\ufe0f \u0633\u062a\u0627\u0631\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0647\u0645\u0647 \u0631\u0627\u0628\u0637\u200c\u0647\u0627\u06cc \u0634\u0628\u06a9\u0647 \u0631\u0627 \u0628\u0627\u0632 \u0645\u06cc\u200c\u06a9\u0646\u062f<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u0645\u0642\u062f\u0627\u0631 &#8216;*&#8217; \u06cc\u0639\u0646\u06cc \u06af\u0648\u0634 \u062f\u0627\u062f\u0646 \u0631\u0648\u06cc \u0647\u0645\u0647 \u0631\u0627\u0628\u0637\u200c\u0647\u0627\u06cc \u0634\u0628\u06a9\u0647. \u0627\u06af\u0631 pg_hba.conf \u0645\u062d\u062f\u0648\u062f \u0646\u0634\u062f\u0647 \u0648 \u067e\u0648\u0631\u062a 5432 \u0628\u0627\u0632 \u0628\u0627\u0634\u062f\u060c \u0647\u0631 \u06a9\u0633\u06cc \u06a9\u0647 \u0628\u0647 \u0622\u0646 IP \u0628\u0631\u0633\u062f \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u062a\u0644\u0627\u0634 \u06a9\u0646\u062f.<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div class=\"wp-block-greenshift-blocks-image gspb_image gspb_image-id-gsbp-d4e79c8\" id=\"gspb_image-id-gsbp-d4e79c8\"><img decoding=\"async\" src=\"https:\/\/webdade.com\/blog\/wp-content\/uploads\/2026\/11\/PostgreSQL-Memory-Tuning-Infographic-1.webp\" data-src=\"\" alt=\"\u0633\u0647\u0645 shared_buffers \u0648 work_mem \u0627\u0632 \u0631\u0645 \u0686\u0642\u062f\u0631 \u0628\u0627\u0634\u062f\u061f\n\" loading=\"lazy\" width=\"1774\" height=\"887\" title=\"\u0633\u0647\u0645 shared_buffers \u0648 work_mem \u0627\u0632 \u0631\u0645 \u0686\u0642\u062f\u0631 \u0628\u0627\u0634\u062f\u061f\n\"\/><\/div>\n\n\n\n<h2 id=\"memory\" class=\"wp-block-heading wd-h2\">\u0633\u0647\u0645 shared_buffers \u0648 work_mem \u0627\u0632 \u0631\u0645 \u0686\u0642\u062f\u0631 \u0628\u0627\u0634\u062f\u061f<\/h2>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u067e\u0627\u0633\u062e \u06a9\u0648\u062a\u0627\u0647:<\/strong> <a href=\"https:\/\/www.postgresql.org\/docs\/16\/runtime-config-resource.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0645\u0635\u0631\u0641 \u0645\u0646\u0627\u0628\u0639 PostgreSQL<\/a> \u0628\u0631\u0627\u06cc \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 1GB \u0631\u0645 \u06cc\u0627 \u0628\u06cc\u0634\u062a\u0631\u060c \u06f2\u06f5 \u062f\u0631\u0635\u062f \u0631\u0645 \u0631\u0627 \u00ab\u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639 \u0645\u0639\u0642\u0648\u0644\u00bb shared_buffers \u0645\u06cc\u200c\u062f\u0627\u0646\u062f. \u0628\u0631\u0627\u06cc work_mem \u062f\u0631\u0635\u062f\u06cc \u0646\u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0647\u0634\u062f\u0627\u0631 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0645\u0635\u0631\u0641 \u06a9\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0686\u0646\u062f \u0628\u0631\u0627\u0628\u0631 \u0647\u0645\u06cc\u0646 \u0639\u062f\u062f \u0634\u0648\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes wd-table\"><table class=\"has-fixed-layout\"><thead><tr><th>\u067e\u0627\u0631\u0627\u0645\u062a\u0631<\/th><th>\u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u062f\u0631 PostgreSQL 16 \u0627\u0648\u0628\u0648\u0646\u062a\u0648<\/th><th>\u0646\u0648\u0639 \u062d\u0627\u0641\u0638\u0647<\/th><th>\u0627\u0639\u0645\u0627\u0644 \u062a\u063a\u06cc\u06cc\u0631<\/th><\/tr><\/thead><tbody><tr><td>shared_buffers<\/td><td>128MB<\/td><td>\u0645\u0634\u062a\u0631\u06a9 \u0628\u06cc\u0646 \u0647\u0645\u0647 \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627<\/td><td>\u0628\u0627 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a<\/td><\/tr><tr><td>work_mem<\/td><td>4MB<\/td><td>\u0628\u0631\u0627\u06cc \u0647\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a sort \u06cc\u0627 hash<\/td><td>\u0628\u0627 reload \u06cc\u0627 SET<\/td><\/tr><tr><td>maintenance_work_mem<\/td><td>64MB<\/td><td>\u0628\u0631\u0627\u06cc VACUUM \u0648 CREATE INDEX<\/td><td>\u0628\u0627 reload \u06cc\u0627 SET<\/td><\/tr><tr><td>effective_cache_size<\/td><td>4GB<\/td><td>\u0628\u062f\u0648\u0646 \u062a\u062e\u0635\u06cc\u0635\u061b \u0641\u0642\u0637 \u062a\u062e\u0645\u06cc\u0646<\/td><td>\u0628\u0627 reload \u06cc\u0627 SET<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 id=\"\u0645\u0642\u062f\u0627\u0631-shared-buffers-\u0631\u0627-\u0686\u0637\u0648\u0631-\u0639\u0648\u0636-\u06a9\u0646\u06cc\u0645\" class=\"wp-block-heading wd-h3\">\u0645\u0642\u062f\u0627\u0631 shared_buffers \u0631\u0627 \u0686\u0637\u0648\u0631 \u0639\u0648\u0636 \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0646\u0635\u0628 PostgreSQL \u0628\u0631\u0627\u06cc shared_buffers\u060c \u06cc\u0639\u0646\u06cc 128MB\u060c \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 4GB \u062d\u062f\u0648\u062f \u0633\u0647 \u062f\u0631\u0635\u062f \u0631\u0645 \u0627\u0633\u062a. \u0627\u06af\u0631 \u0633\u0631\u0648\u0631 \u0641\u0642\u0637 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u06f2\u06f5 \u062f\u0631\u0635\u062f \u06cc\u0639\u0646\u06cc 1GB\u061b \u0627\u06af\u0631 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0647\u0645 \u06a9\u0646\u0627\u0631\u0634 \u0627\u0633\u062a\u060c \u06a9\u0645\u062a\u0631 \u0628\u06af\u0630\u0627\u0631\u06cc\u062f. \u0628\u0647 \u06af\u0641\u062a\u0647 \u0645\u0633\u062a\u0646\u062f\u0627\u062a\u060c \u0628\u06cc\u0634 \u0627\u0632 \u06f4\u06f0 \u062f\u0631\u0635\u062f \u0628\u0639\u06cc\u062f \u0627\u0633\u062a \u0628\u0647\u062a\u0631 \u062c\u0648\u0627\u0628 \u0628\u062f\u0647\u062f\u060c \u0686\u0648\u0646 \u06a9\u0634 \u0633\u06cc\u0633\u062a\u0645\u200c\u0639\u0627\u0645\u0644 \u0647\u0645 \u0628\u0647 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u0622\u06cc\u062f.<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres psql -c \"ALTER SYSTEM SET shared_buffers = '1GB';\"\nsudo systemctl restart postgresql\nsudo -u postgres psql -c \"SHOW shared_buffers;\"<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0633\u062a\u0648\u0631 ALTER SYSTEM \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u062f\u0631 postgresql.auto.conf \u0645\u06cc\u200c\u0646\u0648\u06cc\u0633\u062f. \u0627\u06af\u0631 \u0628\u0647\u200c\u062c\u0627\u06cc \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0641\u0642\u0637 <code>SELECT pg_reload_conf();<\/code> \u0628\u0632\u0646\u06cc\u062f\u060c SHOW \u0647\u0646\u0648\u0632 128MB \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0633\u062a\u0648\u0646 pending_restart \u0645\u0642\u062f\u0627\u0631 t \u062f\u0627\u0631\u062f. \u06cc\u0639\u0646\u06cc \u0633\u0631\u0648\u0631 \u0645\u0646\u062a\u0638\u0631 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0627\u0633\u062a. \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u06cc\u0627\u062f\u0622\u0648\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f shared_buffers \u0628\u0632\u0631\u06af\u200c\u062a\u0631 \u0645\u0639\u0645\u0648\u0644\u0627\u064b max_wal_size \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc \u0647\u0645 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u062f.<\/p>\n\n\n\n<h3 id=\"\u0686\u0631\u0627-work-mem-\u0631\u0627-\u0646\u0628\u0627\u06cc\u062f-\u0645\u062b\u0644-\u0631\u0645-\u062a\u0642\u0633\u06cc\u0645-\u06a9\u0631\u062f\" class=\"wp-block-heading wd-h3\">\u0686\u0631\u0627 work_mem \u0631\u0627 \u0646\u0628\u0627\u06cc\u062f \u0645\u062b\u0644 \u0631\u0645 \u062a\u0642\u0633\u06cc\u0645 \u06a9\u0631\u062f\u061f<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0631 \u0633\u0627\u0644\u0646 \u0645\u0637\u0627\u0644\u0639\u0647 \u06cc\u06a9 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647\u060c \u0642\u0641\u0633\u0647 \u0645\u0634\u062a\u0631\u06a9 \u06a9\u0646\u0627\u0631 \u0645\u06cc\u0632\u0647\u0627 shared_buffers \u0627\u0633\u062a. \u0645\u06cc\u0632 \u0647\u0631 \u0646\u0641\u0631 work_mem \u0627\u0633\u062a\u061b \u062f\u0647 \u0646\u0641\u0631 \u0628\u0627 \u0633\u0647 \u06a9\u062a\u0627\u0628 \u0628\u0627\u0632 \u06cc\u0639\u0646\u06cc \u0633\u06cc \u0633\u0647\u0645 \u0627\u0632 \u0633\u0627\u0644\u0646. \u0637\u0628\u0642 \u0645\u0633\u062a\u0646\u062f\u0627\u062a\u060c \u0647\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a sort \u06cc\u0627 hash \u062f\u0631 \u0647\u0631 \u062c\u0644\u0633\u0647 \u062a\u0627 \u0633\u0642\u0641 work_mem \u062d\u0627\u0641\u0638\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>rough \u2248 work_mem \u00d7 ops_per_query \u00d7 (1 + parallel_workers) \u00d7 active_connections<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group wd-box wd-info is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\ud83d\udca1 \u0628\u0631\u0622\u0648\u0631\u062f \u062a\u0642\u0631\u06cc\u0628\u06cc \u0645\u0635\u0631\u0641 work_mem<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0641\u0631\u0645\u0648\u0644\u06cc \u0646\u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0641\u0642\u0637 \u0645\u06cc\u200c\u06af\u0648\u06cc\u062f \u0645\u0635\u0631\u0641 \u06a9\u0644 \u00ab\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0686\u0646\u062f \u0628\u0631\u0627\u0628\u0631\u00bb work_mem \u0628\u0627\u0634\u062f. \u0639\u0645\u0644\u06cc\u0627\u062a hash \u062a\u0627 \u062f\u0648 \u0628\u0631\u0627\u0628\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f (hash_mem_multiplier \u0628\u0627 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 2.0) \u0648 \u0647\u0631 worker \u0645\u0648\u0627\u0632\u06cc \u0633\u0642\u0641 \u062e\u0648\u062f\u0634 \u0631\u0627 \u062f\u0627\u0631\u062f. \u0645\u062b\u0627\u0644: 8MB \u00d7 \u062f\u0648 \u0639\u0645\u0644\u06cc\u0627\u062a \u00d7 \u06f2\u06f0 \u0627\u062a\u0635\u0627\u0644 \u06cc\u0639\u0646\u06cc \u062d\u062f\u0648\u062f 320MB\u060c \u067e\u06cc\u0634 \u0627\u0632 \u062d\u0633\u0627\u0628 hash \u0648 worker\u0647\u0627.<\/p>\n<\/div>\n\n\n\n<h3 id=\"\u0645\u0642\u062f\u0627\u0631-effective-cache-size-\u0648-maintenance-work-mem\" class=\"wp-block-heading wd-h3\">\u0645\u0642\u062f\u0627\u0631 effective_cache_size \u0648 maintenance_work_mem<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0631 <a href=\"https:\/\/www.postgresql.org\/docs\/16\/runtime-config-query.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632 \u06a9\u0648\u0626\u0631\u06cc<\/a>\u060c effective_cache_size \u0641\u0631\u0636 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632 \u062f\u0631\u0628\u0627\u0631\u0647 \u06a9\u0634 \u062f\u06cc\u0633\u06a9\u06cc \u0627\u0633\u062a \u0648 \u0639\u062f\u062f \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u0634 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u0631\u0627 \u0645\u062d\u062a\u0645\u0644\u200c\u062a\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062f\u0631\u0635\u062f\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0646\u0634\u062f\u0647\u061b shared_buffers \u0648 \u0633\u0647\u0645 PostgreSQL \u0627\u0632 \u06a9\u0634 \u0647\u0633\u062a\u0647 \u0631\u0627 \u0628\u0627 \u0647\u0645 \u062d\u0633\u0627\u0628 \u06a9\u0646\u06cc\u062f. \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 4GB \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 2GB \u0627\u0632 \u06a9\u0644 \u0631\u0645 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0633\u062a\u061b \u0628\u0627 <code>ALTER SYSTEM<\/code> \u0648 reload \u0622\u0646 \u0631\u0627 \u0632\u06cc\u0631 \u0631\u0645 \u0633\u0631\u0648\u0631 \u0628\u06cc\u0627\u0648\u0631\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0647\u0631 worker \u0627\u0632 autovacuum (\u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0633\u0647 \u062a\u0627) \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 maintenance_work_mem \u0628\u06af\u06cc\u0631\u062f\u061b autovacuum_work_mem \u0627\u06cc\u0646 \u0631\u0627 \u062c\u062f\u0627 \u0645\u0647\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u0645 \u0627\u0632 \u0627\u0648\u0644\u060c <a href=\"https:\/\/webdade.com\/blog\/database-server\">\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0631\u0645 \u0628\u0631\u0627\u06cc \u0633\u0631\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/a> \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/p>\n\n\n\n<h2 id=\"remote-access\" class=\"wp-block-heading wd-h2\">\u0686\u0637\u0648\u0631 \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u062c\u0644\u0648\u06cc \u0647\u0645\u0647 \u0646\u06af\u0630\u0627\u0631\u06cc\u0645\u061f<\/h2>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u067e\u0627\u0633\u062e \u06a9\u0648\u062a\u0627\u0647:<\/strong> \u062f\u0631 pg_hba.conf \u0641\u0642\u0637 IP \u0645\u0634\u062e\u0635 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0631\u0627 \u0628\u0627 \u0631\u0648\u0634 scram-sha-256 \u0645\u062c\u0627\u0632 \u06a9\u0646\u06cc\u062f\u060c \u062e\u0637 \u062a\u0627\u0632\u0647 \u0631\u0627 \u0628\u0627 pg_hba_file_rules \u0628\u0633\u0646\u062c\u06cc\u062f\u060c \u0628\u0639\u062f listen_addresses \u0631\u0627 \u0627\u0632 localhost \u0628\u0647 \u0622\u062f\u0631\u0633 \u0633\u0631\u0648\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f \u0648 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0631 \u0646\u0635\u0628 PostgreSQL \u0627\u0632 \u0645\u062e\u0632\u0646 \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u060c listen_addresses \u0631\u0648\u06cc localhost \u0627\u0633\u062a \u0648 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0641\u0642\u0637 \u0627\u0632 \u062e\u0648\u062f \u0633\u0631\u0648\u0631 \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a. \u06a9\u0627\u0631\u0628\u0631 postgres \u0647\u0645 \u0628\u0627 \u0631\u0648\u0634 peer \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u0634\u0648\u062f\u061b \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631 \u0633\u06cc\u0633\u062a\u0645\u200c\u0639\u0627\u0645\u0644 \u0645\u0644\u0627\u06a9 \u0627\u0633\u062a \u0648 \u0631\u0645\u0632 \u0644\u0627\u0632\u0645 \u0646\u06cc\u0633\u062a.<\/p>\n\n\n\n<h3 id=\"\u06cc\u06a9-\u062e\u0637-\u062f\u0631-pg-hba-conf-\u0628\u0631\u0627\u06cc-\u06cc\u06a9-ip\" class=\"wp-block-heading wd-h3\">\u06cc\u06a9 \u062e\u0637 \u062f\u0631 pg_hba.conf\u060c \u0628\u0631\u0627\u06cc \u06cc\u06a9 IP<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062f\u0631 <a href=\"https:\/\/www.postgresql.org\/docs\/16\/auth-pg-hba-conf.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0641\u0627\u06cc\u0644 pg_hba.conf<\/a> \u0627\u0648\u0644\u06cc\u0646 \u062e\u0637 \u0645\u0646\u0637\u0628\u0642 \u0628\u0647 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u0631\u0648\u062f \u0648 \u0627\u06af\u0631 \u0627\u062d\u0631\u0627\u0632 \u0647\u0648\u06cc\u062a \u062f\u0631 \u0622\u0646 \u0634\u06a9\u0633\u062a \u0628\u062e\u0648\u0631\u062f\u060c \u062e\u0637 \u0628\u0639\u062f\u06cc \u0628\u0631\u0631\u0633\u06cc \u0646\u0645\u06cc\u200c\u0634\u0648\u062f. \u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc \u0641\u0627\u06cc\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u061b 198.51.100.7 \u0622\u062f\u0631\u0633 \u0646\u0645\u0648\u0646\u0647 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo nano \/etc\/postgresql\/16\/main\/pg_hba.conf\n# add at the end:\nhost    shop    appuser    198.51.100.7\/32    scram-sha-256<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0631\u0648\u0634 trust \u0631\u0627 \u0628\u0631\u0627\u06cc \u0634\u0628\u06a9\u0647 \u0628\u0647 \u06a9\u0627\u0631 \u0646\u0628\u0631\u06cc\u062f\u061b \u0637\u0628\u0642 \u0645\u0633\u062a\u0646\u062f\u0627\u062a\u060c \u0647\u0631 \u06a9\u0633\u06cc \u0631\u0627 \u0628\u062f\u0648\u0646 \u0631\u0645\u0632 \u0631\u0627\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0646\u0633\u062e\u0647 18 \u0647\u0645 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0627\u0632 \u0631\u0645\u0632\u0647\u0627\u06cc MD5 \u0631\u0627 \u0645\u0646\u0633\u0648\u062e \u0627\u0639\u0644\u0627\u0645 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a. \u0627\u06af\u0631 \u06a9\u0644\u0627\u06cc\u0646\u062a TLS \u062f\u0627\u0631\u062f\u060c hostssl \u0627\u062a\u0635\u0627\u0644 \u0628\u062f\u0648\u0646 \u0631\u0645\u0632\u0646\u06af\u0627\u0631\u06cc \u0631\u0627 \u0646\u0645\u06cc\u200c\u067e\u0630\u06cc\u0631\u062f.<\/p>\n\n\n\n<h3 id=\"\u0628\u0631\u0631\u0633\u06cc-\u062e\u0637-\u0628\u0627\u0632-\u06a9\u0631\u062f\u0646-listen-addresses-\u0648-\u0641\u0627\u06cc\u0631\u0648\u0627\u0644\" class=\"wp-block-heading wd-h3\">\u0628\u0631\u0631\u0633\u06cc \u062e\u0637\u060c \u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 listen_addresses \u0648 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0633\u062a\u0648\u0646 error \u062f\u0631 pg_hba_file_rules \u062e\u0637\u0627\u06cc \u062e\u0637 \u062a\u0627\u0632\u0647 \u0631\u0627 \u067e\u06cc\u0634 \u0627\u0632 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f\u061b \u062f\u0631 \u0622\u0632\u0645\u0627\u06cc\u0634 \u0645\u0627 \u0645\u0627\u0633\u06a9 \u0627\u0634\u062a\u0628\u0627\u0647 \/33 \u0647\u0645\u06cc\u0646\u200c\u062c\u0627 invalid CIDR mask \u062f\u0627\u062f. \u0633\u062a\u0648\u0646 \u062e\u0627\u0644\u06cc \u0628\u0648\u062f\u061f \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u062f:<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres psql -c \"SELECT line_number, address, auth_method, error FROM pg_hba_file_rules;\"\nsudo -u postgres psql -c \"ALTER SYSTEM SET listen_addresses = 'localhost,203.0.113.10';\"\nsudo systemctl restart postgresql\nsudo ufw allow proto tcp from 198.51.100.7 to any port 5432<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0622\u062f\u0631\u0633 203.0.113.10 \u0646\u0645\u0648\u0646\u0647 IP \u0633\u0631\u0648\u0631 \u0627\u0633\u062a\u061b listen_addresses \u0641\u0647\u0631\u0633\u062a \u0628\u0627 \u06a9\u0627\u0645\u0627 \u0645\u06cc\u200c\u067e\u0630\u06cc\u0631\u062f \u0648 &#8216;*&#8217; \u0644\u0627\u0632\u0645 \u0646\u06cc\u0633\u062a. \u0642\u0627\u0646\u0648\u0646 ufw \u067e\u0648\u0631\u062a 5432 \u0631\u0627 \u0641\u0642\u0637 \u0628\u0631\u0627\u06cc \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u0628\u0627\u0632 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0639\u062f\u06cc pg_hba.conf\u060c <code>SELECT pg_reload_conf();<\/code> \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div class=\"wp-block-greenshift-blocks-image gspb_image gspb_image-id-gsbp-3b696fc\" id=\"gspb_image-id-gsbp-3b696fc\"><img decoding=\"async\" src=\"https:\/\/webdade.com\/blog\/wp-content\/uploads\/2026\/11\/PostgreSQL-Backup-or-Query-Analysis-1.webp\" data-src=\"\" alt=\"\u0628\u06a9\u0627\u067e \u0628\u0627 pg_dump \u0648 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0627\u0632 \u06a9\u062c\u0627 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f\" loading=\"lazy\" width=\"1774\" height=\"887\" title=\"\u0628\u06a9\u0627\u067e \u0628\u0627 pg_dump \u0648 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0627\u0632 \u06a9\u062c\u0627 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f\"\/><\/div>\n\n\n\n<h2 id=\"backup-slow\" class=\"wp-block-heading wd-h2\">\u0628\u06a9\u0627\u067e \u0628\u0627 pg_dump \u0648 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0627\u0632 \u06a9\u062c\u0627 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f\u061f<\/h2>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u067e\u0627\u0633\u062e \u06a9\u0648\u062a\u0627\u0647:<\/strong> \u0628\u06a9\u0627\u067e \u0628\u0627 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 pg_dump -Fc \u0628\u0631\u0627\u06cc \u0647\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0634\u0631\u0648\u0639 \u0645\u06cc\u200c\u0634\u0648\u062f. \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0631\u0627 log_min_duration_statement \u062f\u0631 \u0644\u0627\u06af \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 pg_stat_statements \u0622\u0645\u0627\u0631 \u0647\u0645\u0647 \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627 \u0631\u0627 \u062c\u0645\u0639 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n<h3 id=\"\u0628\u06a9\u0627\u067e-\u0648-\u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc-\u0628\u0627-pg-dump\" class=\"wp-block-heading wd-h3\">\u0628\u06a9\u0627\u067e \u0648 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0628\u0627 pg_dump<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0628\u06a9\u0627\u067e \u0627\u0648\u0644 \u0631\u0627 \u067e\u06cc\u0634 \u0627\u0632 \u0648\u0631\u0648\u062f \u062f\u0627\u062f\u0647 \u0648\u0627\u0642\u0639\u06cc \u0628\u06af\u06cc\u0631\u06cc\u062f\u061b \u0633\u0631\u0648\u0631 \u062a\u0627\u0632\u0647 \u0628\u0639\u062f \u0627\u0632 \u0646\u0635\u0628 PostgreSQL \u0628\u0647\u062a\u0631\u06cc\u0646 \u062c\u0627 \u0628\u0631\u0627\u06cc \u062a\u0645\u0631\u06cc\u0646 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u06cc \u0627\u0633\u062a. \u0637\u0628\u0642 <a href=\"https:\/\/www.postgresql.org\/docs\/16\/app-pgdump.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0645\u0633\u062a\u0646\u062f\u0627\u062a pg_dump<\/a>\u060c \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u062d\u06cc\u0646 \u06a9\u0627\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062e\u0631\u0648\u062c\u06cc \u0633\u0627\u0632\u06af\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f \u0648 \u062e\u0648\u0627\u0646\u0646\u062f\u0647\u200c\u0647\u0627 \u0648 \u0646\u0648\u06cc\u0633\u0646\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0645\u0633\u062f\u0648\u062f \u0646\u0645\u06cc\u200c\u06a9\u0646\u062f. \u0642\u0627\u0644\u0628 custom (-Fc) \u0641\u0634\u0631\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres pg_dump -Fc -f \/var\/lib\/postgresql\/shop.dump shop\nsudo -u postgres pg_restore --list \/var\/lib\/postgresql\/shop.dump\nsudo -u postgres createdb shop_test\nsudo -u postgres pg_restore -d shop_test \/var\/lib\/postgresql\/shop.dump<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u062e\u0631\u0648\u062c\u06cc &#8211;list \u0628\u0627\u06cc\u062f \u0633\u0637\u0631 \u00abFormat: CUSTOM\u00bb \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u062f. \u0646\u0642\u0634\u200c\u0647\u0627 (roles) \u0628\u0627 pg_dumpall \u062e\u0631\u0648\u062c\u06cc \u06af\u0631\u0641\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u0631\u0627 \u0628\u0627 scp \u06cc\u0627 rsync \u0628\u06cc\u0631\u0648\u0646 \u0627\u0632 \u0633\u0631\u0648\u0631 \u0646\u06af\u0647 \u062f\u0627\u0631\u06cc\u062f.<\/p>\n\n\n\n<h3 id=\"\u0644\u0627\u06af-\u06a9\u0648\u0626\u0631\u06cc-\u0647\u0627\u06cc-\u06a9\u0646\u062f-\u0648-pg-stat-statements\" class=\"wp-block-heading wd-h3\">\u0644\u0627\u06af \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u06a9\u0646\u062f \u0648 pg_stat_statements<\/h3>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u067e\u0627\u0631\u0627\u0645\u062a\u0631 log_min_duration_statement \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 -1 \u062f\u0627\u0631\u062f\u060c \u06cc\u0639\u0646\u06cc \u062e\u0627\u0645\u0648\u0634. \u0628\u0627 \u0645\u0642\u062f\u0627\u0631 250ms \u0647\u0631 \u062f\u0633\u062a\u0648\u0631\u06cc \u06a9\u0647 \u06f2\u06f5\u06f0 \u0645\u06cc\u0644\u06cc\u200c\u062b\u0627\u0646\u06cc\u0647 \u06cc\u0627 \u0628\u06cc\u0634\u062a\u0631 \u0637\u0648\u0644 \u0628\u06a9\u0634\u062f \u062f\u0631 \u0644\u0627\u06af \u062b\u0628\u062a \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 reload \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a:<\/p>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres psql -c \"ALTER SYSTEM SET log_min_duration_statement = '250ms';\"\nsudo -u postgres psql -c \"SELECT pg_reload_conf();\"\nsudo tail -f \/var\/log\/postgresql\/postgresql-16-main.log<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc \u062e\u0648\u062f \u0645\u0627\u060c <code>SELECT pg_sleep(0.3);<\/code> \u0633\u0637\u0631 <code>duration: 300.836 ms<\/code> \u0631\u0627 \u062b\u0628\u062a \u06a9\u0631\u062f. \u0628\u0631\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc \u0633\u0631\u06cc\u0639 \u0627\u0645\u0627 \u067e\u0631\u062a\u06a9\u0631\u0627\u0631\u060c <a href=\"https:\/\/www.postgresql.org\/docs\/16\/pgstatstatements.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0627\u0641\u0632\u0648\u0646\u0647 pg_stat_statements<\/a> \u062a\u0635\u0648\u06cc\u0631 \u06a9\u0627\u0645\u0644\u200c\u062a\u0631\u06cc \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<div class=\"wp-block-group wd-box wd-tech is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\ud83d\udd38 \u062e\u0637\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u062f\u0648\u0646 shared_preload_libraries \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u0627\u06cc\u0646 \u0627\u0641\u0632\u0648\u0646\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 shared_preload_libraries \u0628\u06cc\u0627\u06cc\u062f \u0648 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u062f. \u0628\u062f\u0648\u0646 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647\u060c \u0627\u0648\u0644\u06cc\u0646 SELECT \u0628\u0627 \u062e\u0637\u0627\u06cc <code>pg_stat_statements must be loaded via shared_preload_libraries<\/code> \u0645\u062a\u0648\u0642\u0641 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u0648\u0644 \u0645\u0642\u062f\u0627\u0631 \u0641\u0639\u0644\u06cc \u0631\u0627 \u0628\u0627 SHOW \u0628\u0628\u06cc\u0646\u06cc\u062f \u0648 \u0627\u06af\u0631 \u062e\u0627\u0644\u06cc \u0646\u0628\u0648\u062f\u060c \u0646\u0627\u0645 \u0627\u0641\u0632\u0648\u0646\u0647 \u0631\u0627 \u0628\u0647 \u0647\u0645\u0627\u0646 \u0641\u0647\u0631\u0633\u062a \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/div>\n\n\n\n<pre class=\"wp-block-code wd-code\"><code>sudo -u postgres psql -c \"SHOW shared_preload_libraries;\"\nsudo -u postgres psql -c \"ALTER SYSTEM SET shared_preload_libraries = 'pg_stat_statements';\"\nsudo systemctl restart postgresql\nsudo -u postgres psql -d shop -c \"CREATE EXTENSION pg_stat_statements;\"\nsudo -u postgres psql -d shop -c \"SELECT query, calls, total_exec_time\n  FROM pg_stat_statements ORDER BY total_exec_time DESC LIMIT 5;\"<\/code><\/pre>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u062c\u0648\u0627\u0628 \u0627\u06cc\u0646 \u067e\u0631\u0633\u0634\u200c\u0647\u0627 \u062f\u0631 \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u06cc\u06a9 \u062e\u0637 \u0627\u0633\u062a\u060c \u0648\u0644\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646\u0634 \u0648\u0642\u062a \u0645\u06cc\u200c\u0628\u0631\u062f:<\/strong><\/p>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordion gs-accordion gspb_accordion-id-gsbp-821f002 togglelogic gspb_accordion\" id=\"gspb_accordion-id-gsbp-821f002\" itemscope itemtype=\"https:\/\/schema.org\/FAQPage\">\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f003 gsopen gspb_accordionItem gspb_accordionItem-id-gsbp-821f003x\" id=\"gspb_accordionitem-gsbp-821f003\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-0\" class=\"gs-accordion-item__title\" aria-expanded=\"true\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f003\"><h3 class=\"gs-accordion-item__heading\">\u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u06a9\u062f\u0627\u0645 \u0646\u0633\u062e\u0647 PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/h3><meta itemprop=\"name\" content=\"\u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u06a9\u062f\u0627\u0645 \u0646\u0633\u062e\u0647 PostgreSQL \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-0\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f003\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f004\" class=\"gspb_text gspb_text-id-gsbp-821f004 \">\u0646\u0633\u062e\u0647 16\u061b \u0647\u0646\u06af\u0627\u0645 \u0646\u0648\u0634\u062a\u0646 \u0627\u06cc\u0646 \u0645\u062a\u0646\u060c 16.15.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f005 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f005x\" id=\"gspb_accordionitem-gsbp-821f005\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-1\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f005\"><h3 class=\"gs-accordion-item__heading\">\u0631\u0645\u0632 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u06a9\u0627\u0631\u0628\u0631 postgres \u0686\u06cc\u0633\u062a\u061f<\/h3><meta itemprop=\"name\" content=\"\u0631\u0645\u0632 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u06a9\u0627\u0631\u0628\u0631 postgres \u0686\u06cc\u0633\u062a\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-1\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f005\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f006\" class=\"gspb_text gspb_text-id-gsbp-821f006 \">\u0648\u0631\u0648\u062f \u0645\u062d\u0644\u06cc \u0628\u0627 \u0631\u0648\u0634 peer \u0627\u0633\u062a \u0648 \u0631\u0645\u0632 \u0646\u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u062f\u061b \u0628\u0631\u0627\u06cc \u0634\u0628\u06a9\u0647\u060c \u06a9\u0627\u0631\u0628\u0631 \u062c\u062f\u0627 \u0628\u0627 createuser &#8211;pwprompt \u0628\u0633\u0627\u0632\u06cc\u062f.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f007 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f007x\" id=\"gspb_accordionitem-gsbp-821f007\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-2\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f007\"><h3 class=\"gs-accordion-item__heading\">\u0686\u0631\u0627 \u0628\u0639\u062f \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631 shared_buffers \u0645\u0642\u062f\u0627\u0631\u0634 \u0639\u0648\u0636 \u0646\u0634\u062f\u061f<\/h3><meta itemprop=\"name\" content=\"\u0686\u0631\u0627 \u0628\u0639\u062f \u0627\u0632 \u062a\u063a\u06cc\u06cc\u0631 shared_buffers \u0645\u0642\u062f\u0627\u0631\u0634 \u0639\u0648\u0636 \u0646\u0634\u062f\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-2\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f007\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f008\" class=\"gspb_text gspb_text-id-gsbp-821f008 \">\u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0641\u0642\u0637 \u0647\u0646\u06af\u0627\u0645 \u0634\u0631\u0648\u0639 \u0633\u0631\u0648\u0631 \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0644\u0627\u0632\u0645 \u0627\u0633\u062a.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f009 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f009x\" id=\"gspb_accordionitem-gsbp-821f009\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-3\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f009\"><h3 class=\"gs-accordion-item__heading\">\u0631\u0648\u06cc \u0633\u0631\u0648\u0631 2GB \u0645\u0642\u062f\u0627\u0631 shared_buffers \u0631\u0627 \u0686\u0646\u062f \u0628\u06af\u0630\u0627\u0631\u0645\u061f<\/h3><meta itemprop=\"name\" content=\"\u0631\u0648\u06cc \u0633\u0631\u0648\u0631 2GB \u0645\u0642\u062f\u0627\u0631 shared_buffers \u0631\u0627 \u0686\u0646\u062f \u0628\u06af\u0630\u0627\u0631\u0645\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-3\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f009\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f010\" class=\"gspb_text gspb_text-id-gsbp-821f010 \">\u0627\u06af\u0631 \u0641\u0642\u0637 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u062d\u062f\u0648\u062f 512MB (\u06f2\u06f5 \u062f\u0631\u0635\u062f) \u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639 \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0627\u0633\u062a\u061b \u0628\u0627 \u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 \u06a9\u0646\u0627\u0631\u0634 \u06a9\u0645\u062a\u0631 \u0628\u06af\u0630\u0627\u0631\u06cc\u062f.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f011 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f011x\" id=\"gspb_accordionitem-gsbp-821f011\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-4\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f011\"><h3 class=\"gs-accordion-item__heading\">\u0622\u06cc\u0627 effective_cache_size \u0631\u0645 \u0633\u0631\u0648\u0631 \u0631\u0627 \u0627\u0634\u063a\u0627\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/h3><meta itemprop=\"name\" content=\"\u0622\u06cc\u0627 effective_cache_size \u0631\u0645 \u0633\u0631\u0648\u0631 \u0631\u0627 \u0627\u0634\u063a\u0627\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-4\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f011\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f012\" class=\"gspb_text gspb_text-id-gsbp-821f012 \">\u062e\u06cc\u0631\u061b \u0637\u0628\u0642 \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u062d\u0627\u0641\u0638\u0647\u200c\u0627\u06cc \u062a\u062e\u0635\u06cc\u0635 \u06cc\u0627 \u0631\u0632\u0631\u0648 \u0646\u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0641\u0642\u0637 \u062f\u0631 \u062a\u062e\u0645\u06cc\u0646 \u0647\u0632\u06cc\u0646\u0647 \u0628\u0647 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u0631\u0648\u062f.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f013 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f013x\" id=\"gspb_accordionitem-gsbp-821f013\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-5\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f013\"><h3 class=\"gs-accordion-item__heading\">\u0622\u06cc\u0627 pg_dump \u0647\u0646\u06af\u0627\u0645 \u0628\u06a9\u0627\u067e \u06a9\u0627\u0631 \u0633\u0627\u06cc\u062a \u0631\u0627 \u0645\u062a\u0648\u0642\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f<\/h3><meta itemprop=\"name\" content=\"\u0622\u06cc\u0627 pg_dump \u0647\u0646\u06af\u0627\u0645 \u0628\u06a9\u0627\u067e \u06a9\u0627\u0631 \u0633\u0627\u06cc\u062a \u0631\u0627 \u0645\u062a\u0648\u0642\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-5\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f013\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f014\" class=\"gspb_text gspb_text-id-gsbp-821f014 \">\u062e\u06cc\u0631\u060c \u062e\u0648\u0627\u0646\u0646\u062f\u0647\u200c\u0647\u0627 \u0648 \u0646\u0648\u06cc\u0633\u0646\u062f\u0647\u200c\u0647\u0627 \u0645\u0633\u062f\u0648\u062f \u0646\u0645\u06cc\u200c\u0634\u0648\u0646\u062f\u061b \u0641\u0642\u0637 \u0631\u0648\u06cc \u062f\u06cc\u0633\u06a9 \u0628\u0627\u0631 \u0645\u06cc\u200c\u06af\u0630\u0627\u0631\u062f.<\/p>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-greenshift-blocks-accordionitem gs-accordion-item gspb_accordionitem-gsbp-821f015 gsclose gspb_accordionItem gspb_accordionItem-id-gsbp-821f015x\" id=\"gspb_accordionitem-gsbp-821f015\" itemscope itemprop=\"mainEntity\" itemtype=\"https:\/\/schema.org\/Question\"><div id=\"gs-trigger-gsbp-821f002-6\" class=\"gs-accordion-item__title\" aria-expanded=\"false\" role=\"button\" tabindex=\"0\" aria-controls=\"gspb-accordion-item-content-gsbp-821f015\"><h3 class=\"gs-accordion-item__heading\">\u0641\u0631\u0642 pg_dump \u0648 pg_dumpall \u0686\u06cc\u0633\u062a\u061f<\/h3><meta itemprop=\"name\" content=\"\u0641\u0631\u0642 pg_dump \u0648 pg_dumpall \u0686\u06cc\u0633\u062a\u061f\"\/><span class=\"iconfortoggle\"><span class=\"gs-iconbefore\"><\/span><span class=\"gs-iconafter\"><\/span><\/span><\/div><div aria-labelledby=\"gs-trigger-gsbp-821f002-6\" class=\"gs-accordion-item__content\" itemscope itemprop=\"acceptedAnswer\" itemtype=\"https:\/\/schema.org\/Answer\" id=\"gspb-accordion-item-content-gsbp-821f015\"><div class=\"gs-accordion-item__text\" itemprop=\"text\">\n<p id=\"gspb_text-id-gsbp-821f016\" class=\"gspb_text gspb_text-id-gsbp-821f016 \">\u062f\u0633\u062a\u0648\u0631 pg_dump \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u062e\u0631\u0648\u062c\u06cc \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f\u061b \u0646\u0642\u0634\u200c\u0647\u0627 \u0648 \u06a9\u0644 \u062e\u0648\u0634\u0647 \u0628\u0627 pg_dumpall.<\/p>\n<\/div><\/div><\/div>\n<\/div>\n\n\n\n<p class=\"wd-p wp-block-paragraph\"><strong>\u062c\u0645\u0639\u200c\u0628\u0646\u062f\u06cc\u061b \u0628\u0639\u062f \u0627\u0632 \u0646\u0635\u0628 PostgreSQL \u0686\u0647 \u0639\u062f\u062f\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0639\u0648\u0636 \u06a9\u0646\u06cc\u0645:<\/strong> \u0627\u0648\u0644 \u0645\u0642\u062f\u0627\u0631\u0647\u0627\u06cc \u0641\u0639\u0644\u06cc \u0648 \u0633\u062a\u0648\u0646 context \u0631\u0627 \u062f\u0631 pg_settings \u0628\u062e\u0648\u0627\u0646\u06cc\u062f \u062a\u0627 \u0628\u062f\u0627\u0646\u06cc\u062f \u06a9\u062f\u0627\u0645 \u062a\u063a\u06cc\u06cc\u0631 \u0631\u06cc\u200c\u0627\u0633\u062a\u0627\u0631\u062a \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u062f. \u0628\u0631\u0627\u06cc shared_buffers \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u060c \u06f2\u06f5 \u062f\u0631\u0635\u062f \u0631\u0645 \u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639 \u062e\u0648\u062f \u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0627\u0633\u062a. \u0628\u0631\u0627\u06cc work_mem \u0641\u0631\u0645\u0648\u0644 \u0631\u0633\u0645\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f\u061b \u0628\u0627 \u0636\u0631\u0628 \u062f\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a \u0648 \u0627\u062a\u0635\u0627\u0644\u200c\u0647\u0627\u06cc \u0641\u0639\u0627\u0644 \u06cc\u06a9 \u0628\u0631\u0622\u0648\u0631\u062f \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0633\u0627\u0632\u06cc\u062f \u0648 hash \u0648 worker\u0647\u0627\u06cc \u0645\u0648\u0627\u0632\u06cc \u0631\u0627 \u0647\u0645 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u067e\u06cc\u0634 \u0627\u0632 \u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a\u060c \u062e\u0637 IP \u0645\u0634\u062e\u0635 \u0631\u0627 \u062f\u0631 pg_hba.conf \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u0648 \u0628\u0633\u0646\u062c\u06cc\u062f\u060c \u0648 \u0627\u0632 \u0631\u0648\u0632 \u0627\u0648\u0644 \u0628\u0627 pg_dump -Fc \u0628\u06a9\u0627\u067e \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0644\u0627\u06af \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0648 pg_stat_statements \u062c\u0627\u06cc \u0631\u0641\u062a\u0646 \u0648\u0642\u062a \u0633\u0631\u0648\u0631 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f.<\/p>\n\n\n\n<div class=\"wp-block-group wd-box wd-cta is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wd-boxt wp-block-paragraph\">\ud83d\ude80 \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0631\u0627 \u062f\u0631 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u062e\u0648\u062f\u062a\u0627\u0646 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f<\/p>\n\n\n\n<p class=\"wd-boxp wp-block-paragraph\">\u067e\u0648\u0634\u0647 \/etc\/postgresql \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645 \u062f\u0631 VS Code \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<div class=\"wp-block-buttons wd-btns is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button wd-btn\"><a class=\"wp-block-button__link wp-element-button\" href=\"https:\/\/webdade.com\/blog\/vscode-remote-ssh-server\">\u0648\u06cc\u0631\u0627\u06cc\u0634 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0628\u0627 VS Code<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wd-p wp-block-paragraph\">\u0633\u0631\u0648\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0634\u0645\u0627 \u0686\u0646\u062f \u06af\u06cc\u06af\u0627\u0628\u0627\u06cc\u062a \u0631\u0645 \u062f\u0627\u0631\u062f \u0648 shared_buffers \u0631\u0627 \u0631\u0648\u06cc \u0686\u0647 \u0639\u062f\u062f\u06cc \u06af\u0630\u0627\u0634\u062a\u0647\u200c\u0627\u06cc\u062f\u061f \u0627\u06af\u0631 \u0647\u0646\u0648\u0632 128MB \u0627\u0633\u062a\u060c \u062e\u062c\u0627\u0644\u062a \u0646\u062f\u0627\u0631\u062f\u061b \u0647\u0645\u06cc\u0646 \u062f\u0648 \u0639\u062f\u062f \u0631\u0627 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u062a\u0627 \u0628\u0627 \u0647\u0645 \u062d\u0633\u0627\u0628\u0634 \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<ul class=\"wp-block-list wd-list\">\n<li>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/www.postgresql.org\/docs\/16\/runtime-config-resource.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0645\u0635\u0631\u0641 \u0645\u0646\u0627\u0628\u0639\u060c PostgreSQL 16<\/a><\/li>\n\n\n\n<li>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/www.postgresql.org\/docs\/16\/runtime-config-query.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0631\u06cc\u0632 \u06a9\u0648\u0626\u0631\u06cc\u060c PostgreSQL 16<\/a><\/li>\n\n\n\n<li>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/www.postgresql.org\/docs\/16\/auth-pg-hba-conf.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0641\u0627\u06cc\u0644 pg_hba.conf\u060c PostgreSQL 16<\/a><\/li>\n\n\n\n<li>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/www.postgresql.org\/docs\/16\/app-pgdump.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0627\u0628\u0632\u0627\u0631 pg_dump\u060c PostgreSQL 16<\/a><\/li>\n\n\n\n<li>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/www.postgresql.org\/docs\/16\/pgstatstatements.html\" rel=\"nofollow noopener\" target=\"_blank\">\u0627\u0641\u0632\u0648\u0646\u0647 pg_stat_statements\u060c PostgreSQL 16<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u067e\u06cc\u0634\u200c\u0641\u0631\u0636\u200c\u0647\u0627\u06cc \u062d\u0627\u0641\u0638\u0647 PostgreSQL 16 \u0631\u0648\u06cc \u0627\u0648\u0628\u0648\u0646\u062a\u0648 24.04 \u0628\u0631\u0627\u06cc \u0645\u0627\u0634\u06cc\u0646 \u0634\u0645\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0634\u062f\u0647\u200c\u0627\u0646\u062f.<br \/>\n\u0645\u0633\u062a\u0646\u062f\u0627\u062a \u0631\u0633\u0645\u06cc \u0648 \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u062a\u0627\u0632\u0647 \u0627\u0648\u0628\u0648\u0646\u062a\u0648\u060c shared_buffers\u060c work_mem \u0648 effective_cache_size \u0631\u0627 \u0631\u0648\u0634\u0646 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f.<br \/>\n\u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a \u0627\u0645\u0646\u060c \u0628\u06a9\u0627\u067e \u0628\u0627 pg_dump \u0648 \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0626\u0631\u06cc \u06a9\u0646\u062f \u0628\u0627 \u062f\u0633\u062a\u0648\u0631\u0647\u0627\u06cc \u0622\u0632\u0645\u0627\u06cc\u0634\u200c\u0634\u062f\u0647 \u0622\u0645\u062f\u0647\u200c\u0627\u0646\u062f.<\/p>\n","protected":false},"author":16,"featured_media":40473,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_gspb_post_css":".gspb_container-id-gsbp-821f001{flex-direction:column;box-sizing:border-box}#gspb_container-id-gsbp-821f001.gspb_container>p:last-of-type{margin-bottom:0}#gspb_container-id-gsbp-821f001.gspb_container{position:relative;box-sizing:border-box}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item.gsclose>.gs-accordion-item__content{overflow:hidden;opacity:0}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item.gsopen>.gs-accordion-item__content{opacity:1;max-height:5000px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title>.gs-accordion-item__heading{outline:0;text-decoration:none;margin:0!important;padding:0!important;flex-grow:1}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{z-index:1;margin:0;cursor:pointer;transition:all .3s ease-in-out;position:relative;display:flex;justify-content:space-between;align-items:center;flex-wrap:nowrap}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{z-index:0;position:relative;max-height:0;will-change:max-height;transition:all .25s ease-out}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{background-color:#f9f9f9}@media (max-width:999.98px){#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{background-color:#f9f9f9}}@media (max-width:689.98px){#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{background-color:#f9f9f9}}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{border-style:solid;border-width:1px;border-color:var(--wp--preset--color--border, #00000012)}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{background-color:#fff}@media (max-width:999.98px){#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{background-color:#fff}}@media (max-width:689.98px){#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{background-color:#fff}}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content{border-color:var(--wp--preset--color--border, #00000012);border-style:solid;border-width:1px;border-top-color:#00000000}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title span.iconfortoggle{margin-left:15px;display:inline-block;height:14px;width:14px;position:relative}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item{margin-bottom:10px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__content>.gs-accordion-item__text,#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{padding:15px 20px}#gspb_accordion-id-gsbp-821f002 .gs-accordion-item>.gs-accordion-item__title{text-align:right;flex-direction:row-reverse}.gs-accordion .gs-accordion-item.gsopen .gs-accordion-item__title .gs-iconafter{transform:rotate(0)}.gs-accordion .gs-accordion-item__title span.iconfortoggle .gs-iconafter,.gs-accordion .gs-accordion-item__title span.iconfortoggle .gs-iconbefore{content:'';width:14px;height:2px;border-radius:2px;background-color:#111;position:absolute;top:6px;left:0}.gs-accordion .gs-accordion-item__title span.iconfortoggle .gs-iconafter{transform:rotate(90deg);transition:all .3s ease-in-out}#gspb_accordion-id-gsbp-821f002{margin-top:10px;margin-bottom:10px}#gspb_image-id-gsbp-3b696fc img,#gspb_image-id-gsbp-74cc63a img,#gspb_image-id-gsbp-d4e79c8 img{vertical-align:top;display:inline-block;box-sizing:border-box;max-width:100%;height:auto}","rank_math_title":"\u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u0648 \u062a\u0646\u0638\u06cc\u0645 \u0645\u0635\u0631\u0641 \u062d\u0627\u0641\u0638\u0647 (2026)","rank_math_description":"\u0646\u0635\u0628 PostgreSQL \u0631\u0648\u06cc \u0633\u0631\u0648\u0631 \u0645\u062c\u0627\u0632\u06cc \u0631\u0627 \u0628\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0645\u0635\u0631\u0641 \u062d\u0627\u0641\u0638\u0647 \u0645\u062a\u0646\u0627\u0633\u0628 \u0628\u0627 \u0631\u0645 \u0633\u0631\u0648\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f\u061b \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u0627\u0635\u0644\u06cc\u060c \u062f\u0633\u062a\u0631\u0633\u06cc \u0631\u06cc\u0645\u0648\u062a \u0627\u0645\u0646 \u0648 \u0628\u06a9\u0627\u067e \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0631\u0627 \u06cc\u0627\u062f \u0628\u06af\u06cc\u0631\u06cc\u062f.","rank_math_focus_keyword":"\u0646\u0635\u0628 postgresql,pg_dump","footnotes":""},"categories":[29],"tags":[],"class_list":["post-39855","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server-training"],"_links":{"self":[{"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/posts\/39855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/comments?post=39855"}],"version-history":[{"count":5,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/posts\/39855\/revisions"}],"predecessor-version":[{"id":40472,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/posts\/39855\/revisions\/40472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/media\/40473"}],"wp:attachment":[{"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/media?parent=39855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/categories?post=39855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webdade.com\/blog\/wp-json\/wp\/v2\/tags?post=39855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}