{"id":5672,"date":"2026-09-15T11:44:48","date_gmt":"2026-09-15T08:44:48","guid":{"rendered":"https:\/\/maram.iq\/blogs\/odoo-postgresql-tuning-case-study\/"},"modified":"2026-09-15T12:30:12","modified_gmt":"2026-09-15T09:30:12","slug":"odoo-postgresql-tuning-case-study","status":"publish","type":"post","link":"https:\/\/maram.iq\/blogs\/odoo-postgresql-tuning-case-study\/","title":{"rendered":"\u062f\u0631\u0627\u0633\u0629 \u062d\u0627\u0644\u0629: \u0642\u064a\u0627\u0633 \u0623\u062f\u0627\u0621 Odoo \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u062a\u062d\u0633\u064a\u0646 PostgreSQL"},"content":{"rendered":"<p>\u0639\u0646\u062f\u0645\u0627 \u064a\u0634\u0643\u0648 \u0645\u0633\u062a\u062e\u062f\u0645\u0648 \u0646\u0638\u0627\u0645 <strong>Odoo<\/strong> \u0645\u0646 \u0628\u0637\u0621 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u0634\u0627\u0634\u0627\u062a \u0627\u0644\u0642\u0648\u0627\u0626\u0645\u060c \u064a\u0643\u0648\u0646 \u0627\u0644\u0633\u0628\u0628 \u063a\u0627\u0644\u0628\u064b\u0627 \u0641\u064a \u0637\u0628\u0642\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0627 \u0641\u064a \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0646\u0641\u0633\u0647. <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u064a\u0628\u062f\u0623 \u0645\u0646 \u0636\u0628\u0637 PostgreSQL \u2014 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062a\u064a \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u064a\u0647\u0627 Odoo \u0628\u0627\u0644\u0643\u0627\u0645\u0644. \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062f\u0631\u0627\u0633\u0629 \u0623\u062c\u0631\u064a\u0646\u0627 \u0642\u064a\u0627\u0633\u064b\u0627 \u0641\u0639\u0644\u064a\u064b\u0627: \u0646\u0635\u0628\u0646\u0627 Odoo 18 \u0639\u0644\u0649 \u062e\u0627\u062f\u0645 \u0645\u0631\u0627\u0645 \u062d\u0642\u064a\u0642\u064a\u060c \u062d\u0645\u0651\u0644\u0646\u0627 \u0642\u0627\u0639\u062f\u0629 \u0628\u0623\u0643\u062b\u0631 \u0645\u0646 \u0645\u0644\u064a\u0648\u0646 \u0633\u0637\u0631 \u0645\u0639\u0627\u0645\u0644\u0627\u062a\u060c \u0648\u0642\u0650\u0633\u0646\u0627 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a <strong>\u0642\u0628\u0644<\/strong> \u0636\u0628\u0637 PostgreSQL \u0648<strong>\u0628\u0639\u062f\u0647<\/strong> \u2014 \u062f\u0648\u0646 \u062a\u063a\u064a\u064a\u0631 \u0623\u064a \u0645\u0643\u0648\u0651\u0646 \u0639\u062a\u0627\u062f. \u0627\u0644\u0646\u062a\u064a\u062c\u0629 \u0627\u0644\u0645\u062e\u062a\u0635\u0631\u0629: <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u0639\u0628\u0631 \u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062d\u062f\u0647\u0627 \u062e\u0641\u0651\u0636 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0628\u0646\u062d\u0648 20% \u0648\u0631\u0641\u0639 \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0646\u062d\u0648 24%.<\/p>\n\n<div class=\"table-of-contents\" style=\"background:#f8fafc;border:1px solid #e2e8f0;border-radius:12px;padding:1.5rem;margin:1.5rem 0\"><p style=\"font-weight:700;font-size:1.05rem;margin-bottom:.75rem\">\u0645\u062d\u062a\u0648\u064a\u0627\u062a \u0627\u0644\u0645\u0642\u0627\u0644<\/p><ul style=\"padding:0;margin:0\"><li style=\"padding:.25rem 0\"><a href=\"#section-1\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0645\u0627\u0630\u0627 \u064a\u0639\u0646\u064a \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u0639\u0644\u0649 \u0645\u0633\u062a\u0648\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u061f<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-2\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0628\u064a\u0626\u0629 \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631: \u0643\u064a\u0641 \u0642\u0650\u0633\u0646\u0627 \u0627\u0644\u0623\u062f\u0627\u0621 \u0628\u0623\u0631\u0642\u0627\u0645 \u062d\u0642\u064a\u0642\u064a\u0629<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-3\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0642\u0628\u0644 \u0627\u0644\u0636\u0628\u0637: \u0645\u0646 \u0623\u064a\u0646 \u064a\u0623\u062a\u064a \u0627\u0644\u0628\u0637\u0621\u061f<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-4\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u062a\u064a \u063a\u064a\u0651\u0631\u0646\u0627\u0647\u0627 \u0641\u064a PostgreSQL<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-5\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0628\u0639\u062f \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo: \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u0628\u0627\u0644\u0623\u0631\u0642\u0627\u0645<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-6\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0648\u0627\u0644\u062a\u0632\u0627\u0645\u0646: \u0623\u064a\u0646 \u064a\u062a\u0648\u0642\u0641 \u0627\u0644\u0636\u0628\u0637\u061f<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-7\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u062f\u0631\u0633 work_mem \u0648\u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0633\u0631\u064a\u0639<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-8\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0645\u0646 \u0648\u0627\u0642\u0639 \u0645\u0631\u0627\u0645<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-9\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u062e\u0637\u0648\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u0639\u0644\u0649 \u062e\u0627\u062f\u0645\u0643<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-10\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0634\u0627\u0626\u0639\u0629<\/a><\/li><li style=\"padding:.25rem 0\"><a href=\"#section-11\" style=\"color:#4f46e5;text-decoration:none\">&#8592; \u0627\u0644\u062e\u0644\u0627\u0635\u0629<\/a><\/li><\/ul><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/maram.iq\/blogs\/wp-content\/uploads\/2026\/08\/odoo-postgres-perf-hero.png\" alt=\"\u0645\u062e\u0637\u0637 \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo: \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u0636\u0628\u0637 PostgreSQL\" width=\"2400\" height=\"1360\" \/><figcaption class=\"wp-element-caption\">\u0632\u0645\u0646 \u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u062a\u0642\u0627\u0631\u064a\u0631 Odoo \u0642\u0628\u0644 \u0627\u0644\u0636\u0628\u0637 (\u0623\u062d\u0645\u0631) \u0648\u0628\u0639\u062f\u0647 (\u0623\u062e\u0636\u0631) \u2014 \u0642\u064a\u0627\u0633 \u0641\u0639\u0644\u064a \u0628\u0623\u062f\u0627\u0629 pgbench.<\/figcaption><\/figure>\n<h2 class=\"wp-block-heading\" id=\"what\">\u0645\u0627\u0630\u0627 \u064a\u0639\u0646\u064a \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u0639\u0644\u0649 \u0645\u0633\u062a\u0648\u0649 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u061f<\/h2>\n<p>Odoo \u0625\u0637\u0627\u0631 \u0639\u0645\u0644 \u0630\u0643\u064a\u060c \u0644\u0643\u0646\u0647 \u0641\u064a \u0627\u0644\u0646\u0647\u0627\u064a\u0629 \u064a\u062d\u0648\u0651\u0644 \u0643\u0644 \u0639\u0645\u0644\u064a\u0629 \u2014 \u0641\u062a\u062d \u0642\u0627\u0626\u0645\u0629 \u0645\u0628\u064a\u0639\u0627\u062a\u060c \u062a\u0648\u0644\u064a\u062f \u062a\u0642\u0631\u064a\u0631 \u0645\u062d\u0627\u0633\u0628\u064a\u060c \u062a\u0631\u062d\u064a\u0644 \u0642\u064a\u062f \u2014 \u0625\u0644\u0649 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a SQL \u062a\u064f\u0646\u0641\u064e\u0651\u0630 \u0639\u0644\u0649 PostgreSQL. \u0644\u0630\u0644\u0643 \u0641\u0625\u0646 <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u0639\u0644\u0649 \u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0642\u0627\u0639\u062f\u0629 \u064a\u0639\u0646\u064a \u062b\u0644\u0627\u062b\u0629 \u0623\u0634\u064a\u0627\u0621: \u0623\u0646 \u062a\u064f\u062d\u0641\u064e\u0638 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0628\u062f\u0644 \u0642\u0631\u0627\u0621\u062a\u0647\u0627 \u0645\u0646 \u0627\u0644\u0642\u0631\u0635\u060c \u0623\u0646 \u064a\u062c\u062f \u0645\u064f\u062e\u0637\u0650\u0651\u0637 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 (planner) \u0645\u0633\u0627\u062d\u0629 \u0630\u0627\u0643\u0631\u0629 \u0643\u0627\u0641\u064a\u0629 \u0644\u0644\u0641\u0631\u0632 \u0648\u0627\u0644\u062a\u062c\u0645\u064a\u0639\u060c \u0648\u0623\u0646 \u064a\u0639\u0631\u0641 \u0623\u0646\u0643 \u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u062a\u062e\u0632\u064a\u0646 \u0633\u0631\u064a\u0639 \u0641\u064a\u062e\u062a\u0627\u0631 \u0627\u0644\u062e\u0637\u0637 \u0627\u0644\u0635\u062d\u064a\u062d\u0629. \u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0644\u0640 PostgreSQL \u0645\u062d\u0627\u0641\u0650\u0638\u0629 \u0639\u0645\u062f\u064b\u0627 \u0643\u064a \u062a\u0639\u0645\u0644 \u0639\u0644\u0649 \u0623\u064a \u062c\u0647\u0627\u0632\u060c \u0648\u0647\u064a \u0628\u0639\u064a\u062f\u0629 \u062a\u0645\u0627\u0645\u064b\u0627 \u0639\u0646 \u0625\u0645\u0643\u0627\u0646\u0627\u062a \u062e\u0627\u062f\u0645 \u0625\u0646\u062a\u0627\u062c\u064a \u062d\u062f\u064a\u062b.<\/p>\n<p>\u0627\u0644\u062c\u0645\u064a\u0644 \u0623\u0646 \u0647\u0630\u0647 \u0627\u0644\u0645\u0643\u0627\u0633\u0628 \u0644\u0627 \u062a\u062a\u0637\u0644\u0628 \u0644\u0645\u0633 \u0643\u0648\u062f Odoo \u0648\u0644\u0627 \u0634\u0631\u0627\u0621 \u0639\u062a\u0627\u062f \u0623\u0642\u0648\u0649 \u2014 \u0628\u0644 \u062a\u0639\u062f\u064a\u0644 \u0645\u0644\u0641 <code>postgresql.conf<\/code> \u0641\u0642\u0637. \u0644\u0643\u0646 \u0643\u064a \u0644\u0627 \u0646\u0643\u062a\u0641\u064a \u0628\u0627\u0644\u0643\u0644\u0627\u0645\u060c \u0642\u0650\u0633\u0646\u0627 \u0627\u0644\u0641\u0631\u0642 \u0628\u0627\u0644\u0623\u0631\u0642\u0627\u0645.<\/p>\n<h2 class=\"wp-block-heading\" id=\"env\">\u0628\u064a\u0626\u0629 \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631: \u0643\u064a\u0641 \u0642\u0650\u0633\u0646\u0627 \u0627\u0644\u0623\u062f\u0627\u0621 \u0628\u0623\u0631\u0642\u0627\u0645 \u062d\u0642\u064a\u0642\u064a\u0629<\/h2>\n<p>\u0644\u062a\u0643\u0648\u0646 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0642\u0627\u0628\u0644\u0629 \u0644\u0644\u062a\u0635\u062f\u064a\u0642 \u0648\u0627\u0644\u062a\u0643\u0631\u0627\u0631\u060c \u0628\u0646\u064a\u0646\u0627 \u0628\u064a\u0626\u0629 Odoo \u062d\u0642\u064a\u0642\u064a\u0629 \u0644\u0627 \u0645\u062d\u0627\u0643\u0627\u0629 \u0646\u0638\u0631\u064a\u0629. \u062b\u0628\u0651\u062a\u0646\u0627 Odoo 18 \u0645\u0639 \u0648\u062d\u062f\u0627\u062a \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0648\u0627\u0644\u0645\u062d\u0627\u0633\u0628\u0629 \u0648\u0627\u0644\u0645\u062e\u0632\u0648\u0646 \u0648\u0627\u0644\u0645\u0634\u062a\u0631\u064a\u0627\u062a \u0648\u0628\u064a\u0627\u0646\u0627\u062a\u0647\u0627 \u0627\u0644\u062a\u062c\u0631\u064a\u0628\u064a\u0629\u060c \u062b\u0645 \u0636\u062e\u0651\u0645\u0646\u0627 \u062c\u062f\u0648\u0644\u064e\u064a \u0627\u0644\u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u064a\u0646 (\u0623\u0633\u0637\u0631 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0648\u0623\u0633\u0637\u0631 \u0627\u0644\u0642\u064a\u0648\u062f) \u0625\u0644\u0649 \u0623\u062d\u062c\u0627\u0645 \u062a\u0634\u0628\u0647 \u0634\u0631\u0643\u0629 \u0628\u0639\u062f \u0633\u0646\u0648\u0627\u062a \u0645\u0646 \u0627\u0644\u062a\u0634\u063a\u064a\u0644. \u0627\u0644\u0642\u064a\u0627\u0633 \u062a\u0645\u0651 \u0628\u0623\u062f\u0627\u0629 <code>pgbench<\/code> \u0627\u0644\u0631\u0633\u0645\u064a\u0629\u060c \u0628\u062a\u0634\u063a\u064a\u0644 \u0645\u062f\u062a\u0647 30 \u062b\u0627\u0646\u064a\u0629 \u0644\u0643\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u060c \u0645\u0631\u0629 \u0628\u0639\u0645\u064a\u0644 \u0648\u0627\u062d\u062f \u0644\u0642\u064a\u0627\u0633 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0627\u0644\u0635\u0627\u0641\u064a.<\/p>\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>\u0627\u0644\u0639\u0646\u0635\u0631<\/th><th>\u0627\u0644\u0642\u064a\u0645\u0629<\/th><\/tr><\/thead><tbody><tr><td>\u0646\u0638\u0627\u0645 ERP<\/td><td>Odoo 18 Community<\/td><\/tr><tr><td>\u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/td><td>PostgreSQL 16<\/td><\/tr><tr><td>\u0646\u0638\u0627\u0645 \u0627\u0644\u062a\u0634\u063a\u064a\u0644<\/td><td>Ubuntu 24.04 LTS<\/td><\/tr><tr><td>\u0627\u0644\u0645\u0639\u0627\u0644\u062c<\/td><td>Intel Xeon \u2014 4 vCPU<\/td><\/tr><tr><td>\u0627\u0644\u0630\u0627\u0643\u0631\u0629<\/td><td>7.8 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a<\/td><\/tr><tr><td>\u0627\u0644\u062a\u062e\u0632\u064a\u0646<\/td><td>SSD<\/td><\/tr><tr><td>\u062d\u062c\u0645 \u0627\u0644\u0642\u0627\u0639\u062f\u0629<\/td><td>485 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a<\/td><\/tr><tr><td>\u0623\u0633\u0637\u0631 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a (sale_order_line)<\/td><td>560,056<\/td><\/tr><tr><td>\u0623\u0633\u0637\u0631 \u0627\u0644\u0642\u064a\u0648\u062f (account_move_line)<\/td><td>570,057<\/td><\/tr><tr><td>\u0623\u062f\u0627\u0629 \u0627\u0644\u0642\u064a\u0627\u0633<\/td><td>pgbench \u2014 30 \u062b\u0627\u0646\u064a\u0629 \u0644\u0643\u0644 \u062a\u0634\u063a\u064a\u0644<\/td><\/tr><\/tbody><\/table><\/figure>\n<p>\u0623\u0645\u0627 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0641\u0627\u062e\u062a\u0631\u0646\u0627\u0647\u0627 \u0644\u062a\u064f\u0645\u062b\u0651\u0644 \u0639\u0645\u0644 Odoo \u0627\u0644\u064a\u0648\u0645\u064a: \u062a\u0642\u0631\u064a\u0631 \u0645\u0628\u064a\u0639\u0627\u062a \u064a\u062c\u0645\u0639 \u0627\u0644\u0642\u064a\u0645 \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u064a\u0644\u060c \u062a\u0642\u0631\u064a\u0631 \u0645\u062d\u0627\u0633\u0628\u064a \u064a\u062c\u0645\u0639 \u0627\u0644\u0623\u0631\u0635\u062f\u0629 \u062d\u0633\u0628 \u0627\u0644\u062d\u0633\u0627\u0628\u060c \u0648\u062a\u0642\u0631\u064a\u0631 \u0645\u0646\u062a\u062c\u0627\u062a \u064a\u0631\u0628\u0637 \u062b\u0644\u0627\u062b\u0629 \u062c\u062f\u0627\u0648\u0644. \u0647\u0630\u0647 \u0628\u0627\u0644\u0636\u0628\u0637 \u0623\u0646\u0648\u0627\u0639 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u064a \u062a\u064f\u0628\u0637\u0626 \u0634\u0627\u0634\u0627\u062a \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u062d\u064a\u0646 \u062a\u0643\u0628\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<h2 class=\"wp-block-heading\" id=\"before\">\u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0642\u0628\u0644 \u0627\u0644\u0636\u0628\u0637: \u0645\u0646 \u0623\u064a\u0646 \u064a\u0623\u062a\u064a \u0627\u0644\u0628\u0637\u0621\u061f<\/h2>\n<p>\u0628\u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629\u060c \u0643\u0627\u0646 <code>shared_buffers<\/code> \u064a\u0633\u0627\u0648\u064a 128 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0641\u0642\u0637 \u2014 \u0623\u064a \u0623\u0646 PostgreSQL \u064a\u062d\u062a\u0641\u0638 \u0628\u062c\u0632\u0621 \u0636\u0626\u064a\u0644 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0630\u0627\u0643\u0631\u062a\u0647 \u0627\u0644\u062e\u0627\u0635\u0629 \u0648\u064a\u0639\u064a\u062f \u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0628\u0627\u0642\u064a \u0645\u0631\u0627\u0631\u064b\u0627. \u0648\u0623\u0638\u0647\u0631 \u0623\u0645\u0631 <code>EXPLAIN (ANALYZE, BUFFERS)<\/code> \u0623\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u062a\u0642\u0631\u0623 \u0622\u0644\u0627\u0641 \u0627\u0644\u0643\u062a\u0644 \u0645\u0646 \u0627\u0644\u0642\u0631\u0635 \u0641\u064a \u0643\u0644 \u0645\u0631\u0629\u060c \u0648\u0623\u0646 \u0627\u0644\u0641\u0631\u0632 \u064a\u062a\u0633\u0631\u0651\u0628 \u0625\u0644\u0649 \u0627\u0644\u0642\u0631\u0635 \u0644\u0623\u0646 <code>work_mem<\/code> \u0644\u0627 \u064a\u062a\u062c\u0627\u0648\u0632 4 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a. \u0645\u062a\u0648\u0633\u0637 \u0632\u0645\u0646 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0627\u0644\u062b\u0644\u0627\u062b\u0629 \u0643\u0627\u0646 \u0646\u062d\u0648 <strong>124 \u0645\u064a\u0644\u064a \u062b\u0627\u0646\u064a\u0629<\/strong> \u0644\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u0648\u0627\u062d\u062f. \u0647\u0630\u0627 \u0647\u0648 \u062e\u0637 \u0627\u0644\u0623\u0633\u0627\u0633 \u0627\u0644\u0623\u0645\u064a\u0646 \u0627\u0644\u0630\u064a \u0633\u0646\u0642\u064a\u0633 \u0639\u0644\u064a\u0647.<\/p>\n<div class=\"wp-block-group\" style=\"border-left-color:#dc2626;border-left-width:5px;background-color:#fef2f2;padding:16px 18px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><p><strong>\u0644\u0645\u0627\u0630\u0627 \u0644\u0627 \u0646\u0628\u0627\u0644\u063a \u0641\u064a &#8220;\u0642\u0628\u0644&#8221;\u061f<\/strong> \u0634\u063a\u0651\u0644\u0646\u0627 <code>VACUUM ANALYZE<\/code> \u0642\u0628\u0644 \u0642\u064a\u0627\u0633 \u062e\u0637 \u0627\u0644\u0623\u0633\u0627\u0633 \u062a\u0645\u0627\u0645\u064b\u0627 \u0643\u0645\u0627 \u064a\u0641\u0639\u0644 autovacuum \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0641\u064a \u0623\u064a \u062a\u062b\u0628\u064a\u062a \u0625\u0646\u062a\u0627\u062c\u064a\u060c \u062d\u062a\u0649 \u0644\u0627 \u064a\u0623\u062a\u064a \u0627\u0644\u062a\u062d\u0633\u0651\u0646 \u0645\u0646 \u0625\u062d\u0635\u0627\u0621\u0627\u062a \u0646\u0627\u0642\u0635\u0629 \u0628\u0644 \u0645\u0646 \u0627\u0644\u0636\u0628\u0637 \u0627\u0644\u0641\u0639\u0644\u064a \u0648\u062d\u062f\u0647.<\/p><\/div><\/div>\n<h2 class=\"wp-block-heading\" id=\"config\">\u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u062a\u064a \u063a\u064a\u0651\u0631\u0646\u0627\u0647\u0627 \u0641\u064a PostgreSQL<\/h2>\n<p>\u0637\u0628\u0651\u0642\u0646\u0627 \u0645\u062c\u0645\u0648\u0639\u0629 \u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0645\u062a\u0648\u0627\u0632\u0646\u0629 \u062a\u0646\u0627\u0633\u0628 \u062e\u0627\u062f\u0645\u064b\u0627 \u0628\u0623\u0631\u0628\u0639 \u0623\u0646\u0648\u064a\u0629 \u0648\u0630\u0627\u0643\u0631\u0629 7.8 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0648\u062a\u062e\u0632\u064a\u0646 SSD\u060c \u062b\u0645 \u0623\u0639\u062f\u0646\u0627 \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u062e\u062f\u0645\u0629. \u0647\u0630\u0647 \u0647\u064a \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u062f\u0642\u064a\u0642\u0629 \u0627\u0644\u062a\u064a \u063a\u064a\u0651\u0631\u0646\u0627\u0647\u0627:<\/p>\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/maram.iq\/blogs\/wp-content\/uploads\/2026\/08\/odoo-postgres-perf-config.png\" alt=\"\u062c\u062f\u0648\u0644 \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo: \u0625\u0639\u062f\u0627\u062f\u0627\u062a postgresql.conf \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u0627\u0644\u0636\u0628\u0637\" width=\"2400\" height=\"1440\" \/><figcaption class=\"wp-element-caption\">\u0627\u0644\u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u062a\u0633\u0639\u0629 \u0627\u0644\u062a\u064a \u063a\u064a\u0651\u0631\u0646\u0627\u0647\u0627 \u0641\u064a postgresql.conf \u2014 \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0627\u0641\u062a\u0631\u0627\u0636\u064a\u0629 \u0645\u0642\u0627\u0628\u0644 \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0645\u0636\u0628\u0648\u0637\u0629.<\/figcaption><\/figure>\n<ul class=\"wp-block-list\"><li><strong>shared_buffers<\/strong>: \u0631\u0641\u0639\u0646\u0627\u0647 \u0645\u0646 128 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0625\u0644\u0649 2 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a (\u0646\u062d\u0648 25% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629) \u0644\u064a\u0628\u0642\u0649 \u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u0633\u0627\u062e\u0646 \u0645\u0646 \u0628\u064a\u0627\u0646\u0627\u062a Odoo \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629.<\/li><li><strong>effective_cache_size<\/strong>: \u0645\u0646 4 \u0625\u0644\u0649 5.5 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0644\u064a\u0639\u0631\u0641 \u0627\u0644\u0645\u064f\u062e\u0637\u0650\u0651\u0637 \u0643\u0645 \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0645\u062a\u0627\u062d \u0641\u0639\u0644\u064a\u064b\u0627 \u0644\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0645\u0624\u0642\u062a.<\/li><li><strong>work_mem<\/strong>: \u0645\u0646 4 \u0625\u0644\u0649 32 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0644\u0625\u0628\u0642\u0627\u0621 \u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0641\u0631\u0632 \u0648\u0627\u0644\u062a\u062c\u0645\u064a\u0639 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629.<\/li><li><strong>random_page_cost<\/strong>: \u0645\u0646 4.0 \u0625\u0644\u0649 1.1 \u0644\u0623\u0646 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 SSD \u0644\u0627 \u064a\u0639\u0627\u0642\u0628 \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0639\u0634\u0648\u0627\u0626\u064a\u0629 \u0643\u0627\u0644\u0642\u0631\u0635 \u0627\u0644\u062f\u0648\u0651\u0627\u0631.<\/li><li><strong>effective_io_concurrency<\/strong>: \u0645\u0646 1 \u0625\u0644\u0649 200 \u0644\u0627\u0633\u062a\u063a\u0644\u0627\u0644 \u062a\u0648\u0627\u0632\u064a \u0627\u0644\u0625\u062f\u062e\u0627\u0644\/\u0627\u0644\u0625\u062e\u0631\u0627\u062c \u0641\u064a \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u062d\u062f\u064a\u062b.<\/li><li><strong>max_parallel_workers_per_gather<\/strong>: \u0645\u0646 2 \u0625\u0644\u0649 4 \u0644\u0627\u0633\u062a\u063a\u0644\u0627\u0644 \u0627\u0644\u0623\u0646\u0648\u064a\u0629 \u0627\u0644\u0623\u0631\u0628\u0639 \u0641\u064a \u0627\u0644\u0645\u0633\u062d \u0627\u0644\u0645\u062a\u0648\u0627\u0632\u064a.<\/li><li><strong>jit<\/strong>: \u0639\u0637\u0651\u0644\u0646\u0627\u0647 \u0644\u0623\u0646 \u0643\u0644\u0641\u0629 \u062a\u0648\u0644\u064a\u062f \u0627\u0644\u0634\u064a\u0641\u0631\u0629 \u0644\u062d\u0638\u064a\u064b\u0627 \u062a\u0636\u0631\u0651 \u0628\u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0642\u0635\u064a\u0631\u0629 \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629 \u0623\u0643\u062b\u0631 \u0645\u0645\u0627 \u062a\u0646\u0641\u0639.<\/li><\/ul>\n<h2 class=\"wp-block-heading\" id=\"after\">\u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0628\u0639\u062f \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo: \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u0628\u0627\u0644\u0623\u0631\u0642\u0627\u0645<\/h2>\n<p>\u0628\u0639\u062f \u0627\u0644\u0636\u0628\u0637 \u0641\u0642\u0637 \u2014 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0646\u0641\u0633\u0647\u0627\u060c \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0646\u0641\u0633\u0647\u0627\u060c \u0627\u0644\u0639\u062a\u0627\u062f \u0646\u0641\u0633\u0647 \u2014 \u0627\u0646\u062e\u0641\u0636 \u0632\u0645\u0646 \u0643\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0628\u062b\u0628\u0627\u062a. \u0647\u0630\u0647 \u0646\u062a\u0627\u0626\u062c <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u0627\u0644\u0641\u0639\u0644\u064a\u0629 \u0627\u0644\u0645\u0642\u064a\u0633\u0629 \u0628\u0639\u0645\u064a\u0644 \u0648\u0627\u062d\u062f:<\/p>\n<figure class=\"wp-block-table is-style-stripes\"><table><thead><tr><th>\u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645<\/th><th>\u0632\u0645\u0646 \u0642\u0628\u0644 (ms)<\/th><th>\u0632\u0645\u0646 \u0628\u0639\u062f (ms)<\/th><th>\u0627\u0644\u062a\u062d\u0633\u0651\u0646<\/th><th>\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0642\u0628\u0644 (tps)<\/th><th>\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0628\u0639\u062f (tps)<\/th><\/tr><\/thead><tbody><tr><td>\u062a\u0642\u0631\u064a\u0631 \u0645\u0628\u064a\u0639\u0627\u062a \u062d\u0633\u0628 \u0627\u0644\u0639\u0645\u064a\u0644<\/td><td>120.3<\/td><td>97.4<\/td><td>\u200e\u221219%\u200e<\/td><td>8.31<\/td><td>10.27<\/td><\/tr><tr><td>\u0642\u064a\u0648\u062f \u0645\u062d\u0627\u0633\u0628\u064a\u0629 \u062d\u0633\u0628 \u0627\u0644\u062d\u0633\u0627\u0628<\/td><td>101.7<\/td><td>81.9<\/td><td>\u200e\u221219%\u200e<\/td><td>9.83<\/td><td>12.20<\/td><\/tr><tr><td>\u062a\u0642\u0631\u064a\u0631 \u0645\u0646\u062a\u062c\u0627\u062a (\u0631\u0628\u0637 \u062b\u0644\u0627\u062b\u064a)<\/td><td>151.1<\/td><td>118.6<\/td><td>\u200e\u221222%\u200e<\/td><td>6.62<\/td><td>8.43<\/td><\/tr><tr><td><strong>\u0627\u0644\u0645\u062a\u0648\u0633\u0637<\/strong><\/td><td><strong>124.4<\/strong><\/td><td><strong>99.3<\/strong><\/td><td><strong>\u200e\u221220%\u200e<\/strong><\/td><td><strong>8.25<\/strong><\/td><td><strong>10.30<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n<p>\u0627\u0646\u062e\u0641\u0636 \u0645\u062a\u0648\u0633\u0637 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0645\u0646 124 \u0625\u0644\u0649 99 \u0645\u064a\u0644\u064a \u062b\u0627\u0646\u064a\u0629 (\u200e\u221220%\u200e)\u060c \u0648\u0627\u0631\u062a\u0641\u0639\u062a \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0645\u0646 8.25 \u0625\u0644\u0649 10.3 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0641\u064a \u0627\u0644\u062b\u0627\u0646\u064a\u0629 (\u200e+24%\u200e). \u0642\u062f \u064a\u0628\u062f\u0648 \u0627\u0644\u0631\u0642\u0645 \u0645\u062a\u0648\u0627\u0636\u0639\u064b\u0627 \u0645\u0642\u0627\u0628\u0644 \u0648\u0639\u0648\u062f &#8220;\u0623\u0636\u0639\u0627\u0641 \u0627\u0644\u0633\u0631\u0639\u0629&#8221; \u0627\u0644\u062a\u064a \u062a\u0631\u0627\u0647\u0627 \u0623\u062d\u064a\u0627\u0646\u064b\u0627\u060c \u0644\u0643\u0646\u0647 <strong>\u0631\u0642\u0645 \u062d\u0642\u064a\u0642\u064a \u0645\u0642\u064a\u0633<\/strong> \u0639\u0644\u0649 \u0642\u0627\u0639\u062f\u0629 Odoo \u0641\u0639\u0644\u064a\u0629 \u2014 \u0648\u062a\u062d\u0633\u064a\u0646 \u062b\u0627\u0628\u062a \u0628\u0646\u0633\u0628\u0629 \u0627\u0644\u062e\u064f\u0645\u0633 \u0639\u0644\u0649 \u0643\u0644 \u062a\u0642\u0631\u064a\u0631 \u064a\u0639\u0646\u064a \u0634\u0627\u0634\u0627\u062a \u0623\u0633\u0631\u0639 \u0645\u062d\u0633\u0648\u0633\u0629 \u0644\u0643\u0644 \u0645\u0633\u062a\u062e\u062f\u0645\u060c \u0645\u062c\u0627\u0646\u064b\u0627.<\/p>\n<h2 class=\"wp-block-heading\" id=\"concurrency\">\u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0648\u0627\u0644\u062a\u0632\u0627\u0645\u0646: \u0623\u064a\u0646 \u064a\u062a\u0648\u0642\u0641 \u0627\u0644\u0636\u0628\u0637\u061f<\/h2>\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/maram.iq\/blogs\/wp-content\/uploads\/2026\/08\/odoo-postgres-perf-throughput.png\" alt=\"\u0645\u062e\u0637\u0637 \u0625\u0646\u062a\u0627\u062c\u064a\u0629 Odoo: \u0639\u062f\u062f \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0641\u064a \u0627\u0644\u062b\u0627\u0646\u064a\u0629 \u0642\u0628\u0644 \u0648\u0628\u0639\u062f \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo\" width=\"2400\" height=\"1280\" \/><figcaption class=\"wp-element-caption\">\u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 (\u0627\u0633\u062a\u0639\u0644\u0627\u0645\/\u062b\u0627\u0646\u064a\u0629) \u0644\u0643\u0644 \u062a\u0642\u0631\u064a\u0631 \u0642\u0628\u0644 \u0627\u0644\u0636\u0628\u0637 \u0648\u0628\u0639\u062f\u0647\u060c \u0645\u0639 \u0645\u0644\u0627\u062d\u0638\u0629 \u0635\u0631\u064a\u062d\u0629 \u0639\u0646 \u062d\u062f\u0648\u062f \u0627\u0644\u062a\u0632\u0627\u0645\u0646.<\/figcaption><\/figure>\n<p>\u062d\u064a\u0646 \u0643\u0631\u0631\u0646\u0627 \u0627\u0644\u0642\u064a\u0627\u0633 \u0628\u0623\u0631\u0628\u0639\u0629 \u0639\u0645\u0644\u0627\u0621 \u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646\u060c \u0643\u0627\u0646 \u0627\u0644\u062a\u062d\u0633\u0651\u0646 \u0636\u0626\u064a\u0644\u064b\u0627 \u062c\u062f\u064b\u0627. \u0627\u0644\u0633\u0628\u0628 \u0623\u0645\u064a\u0646 \u0648\u0648\u0627\u0636\u062d: \u0639\u0644\u0649 \u062e\u0627\u062f\u0645 \u0628\u0623\u0631\u0628\u0639 \u0623\u0646\u0648\u064a\u0629\u060c \u0623\u0631\u0628\u0639\u0629 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u062b\u0642\u064a\u0644\u0629 \u0645\u062a\u0632\u0627\u0645\u0646\u0629 (\u0643\u0644\u064c\u0651 \u0645\u0646\u0647\u0627 \u064a\u0633\u062a\u062e\u062f\u0645 \u0639\u0645\u0651\u0627\u0644\u064b\u0627 \u0645\u062a\u0648\u0627\u0632\u064a\u0646) \u062a\u064f\u0634\u0628\u0639 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u0628\u0627\u0644\u0643\u0627\u0645\u0644. \u0627\u0644\u0636\u0628\u0637 \u064a\u0642\u0644\u0651\u0644 \u0627\u0644\u0639\u0645\u0644 \u0644\u0643\u0644 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u060c \u0644\u0643\u0646\u0647 \u0644\u0627 \u064a\u0636\u064a\u0641 \u0623\u0646\u0648\u064a\u0629. \u0647\u0630\u0647 \u0646\u0642\u0637\u0629 \u062c\u0648\u0647\u0631\u064a\u0629:<\/p>\n<div class=\"wp-block-group\" style=\"border-left-color:#f59e0b;border-left-width:5px;background-color:#fffbeb;padding:16px 18px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><p><strong>\u0627\u0644\u062e\u0644\u0627\u0635\u0629 \u0627\u0644\u0635\u0627\u062f\u0642\u0629<\/strong> \u0636\u0628\u0637 PostgreSQL \u064a\u062e\u0641\u0636 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0627\u0644\u0648\u0627\u062d\u062f \u0648\u064a\u062d\u0633\u0651\u0646 \u062a\u062c\u0631\u0628\u0629 \u0643\u0644 \u0645\u0633\u062a\u062e\u062f\u0645\u060c \u0644\u0643\u0646 \u062e\u062f\u0645\u0629 \u0639\u062f\u062f \u0623\u0643\u0628\u0631 \u0645\u0646 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646 \u062a\u062a\u0637\u0644\u0628 \u0632\u064a\u0627\u062f\u0629 \u0639\u062f\u062f \u0627\u0644\u0623\u0646\u0648\u064a\u0629 (\u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u062e\u0637\u0629) \u2014 \u0644\u0627 \u0645\u062c\u0631\u062f \u0636\u0628\u0637 \u0627\u0644\u0642\u0627\u0639\u062f\u0629. \u0627\u0644\u0636\u0628\u0637 \u0648\u0627\u0644\u062a\u0631\u0642\u064a\u0629 \u0623\u062f\u0627\u062a\u0627\u0646 \u0645\u0643\u0645\u0651\u0644\u062a\u0627\u0646 \u0644\u0627 \u0628\u062f\u064a\u0644\u062a\u0627\u0646.<\/p><\/div><\/div>\n<h2 class=\"wp-block-heading\" id=\"workmem\">\u062f\u0631\u0633 work_mem \u0648\u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0633\u0631\u064a\u0639<\/h2>\n<p>\u0623\u0631\u062f\u0646\u0627 \u0623\u0646 \u0646\u0639\u0631\u0641 \u0643\u0645 \u064a\u0633\u0627\u0647\u0645 \u0643\u0644 \u0625\u0639\u062f\u0627\u062f \u0639\u0644\u0649 \u062d\u062f\u0629\u060c \u0641\u0627\u062e\u062a\u0628\u0631\u0646\u0627 \u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0641\u0631\u0632 \u0643\u0628\u064a\u0631\u064b\u0627 \u0645\u0631\u0629 \u0628\u0640 <code>work_mem<\/code> \u0627\u0641\u062a\u0631\u0627\u0636\u064a (4 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a) \u0648\u0645\u0631\u0629 \u0645\u0636\u0628\u0648\u0637\u064b\u0627 (64 \u0645\u064a\u062c\u0627\u0628\u0627\u064a\u062a). \u0639\u0646\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0635\u063a\u064a\u0631\u0629 \u0623\u0638\u0647\u0631 \u0627\u0644\u0645\u064f\u062e\u0637\u0650\u0651\u0637 &#8220;\u0641\u0631\u0632\u064b\u0627 \u062e\u0627\u0631\u062c\u064a\u064b\u0627 \u0639\u0644\u0649 \u0627\u0644\u0642\u0631\u0635&#8221;\u060c \u0648\u0639\u0646\u062f \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u062a\u062d\u0648\u0651\u0644 \u0625\u0644\u0649 &#8220;\u0641\u0631\u0632 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629&#8221; \u2014 \u0644\u0643\u0646 \u0632\u0645\u0646 \u0627\u0644\u062a\u0646\u0641\u064a\u0630 \u062a\u063a\u064a\u0651\u0631 \u0628\u0627\u0644\u0643\u0627\u062f (516 \u0645\u0642\u0627\u0628\u0644 507 \u0645\u064a\u0644\u064a \u062b\u0627\u0646\u064a\u0629).<\/p>\n<p>\u0627\u0644\u0633\u0628\u0628 \u0623\u0646 \u062a\u062e\u0632\u064a\u0646 \u0645\u0631\u0627\u0645 \u0627\u0644\u0633\u0631\u064a\u0639 (SSD\/NVMe) \u064a\u062c\u0639\u0644 \u062d\u062a\u0649 \u0627\u0644\u0641\u0631\u0632 \u0627\u0644\u0645\u062a\u0633\u0631\u0651\u0628 \u0644\u0644\u0642\u0631\u0635 \u0631\u062e\u064a\u0635\u064b\u0627. \u0647\u0630\u0627 \u062f\u0631\u0633 \u0645\u0647\u0645 \u0641\u064a <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong>: \u0623\u062b\u0631 \u0643\u0644 \u0625\u0639\u062f\u0627\u062f \u064a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0639\u062a\u0627\u062f\u0643. \u0639\u0644\u0649 \u062a\u062e\u0632\u064a\u0646 \u0628\u0637\u064a\u0621 \u064a\u0635\u0628\u062d <code>work_mem<\/code> \u062d\u0627\u0633\u0645\u064b\u0627\u060c \u0623\u0645\u0627 \u0639\u0644\u0649 \u062a\u062e\u0632\u064a\u0646 \u0645\u0631\u0627\u0645 \u0627\u0644\u0633\u0631\u064a\u0639 \u0641\u0627\u0644\u0645\u0643\u0627\u0633\u0628 \u0627\u0644\u0623\u0643\u0628\u0631 \u062a\u0623\u062a\u064a \u0645\u0646 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0645\u0624\u0642\u062a \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0648\u062a\u0639\u0637\u064a\u0644 jit \u0648\u0627\u0644\u062a\u0648\u0627\u0632\u064a. \u0627\u0644\u0642\u064a\u0627\u0633 \u0639\u0644\u0649 \u0628\u064a\u0626\u062a\u0643 \u0647\u0648 \u0627\u0644\u0641\u064a\u0635\u0644\u060c \u0644\u0627 \u0627\u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0639\u0627\u0645\u0629.<\/p>\n<h2 class=\"wp-block-heading\" id=\"maram\">\u0645\u0646 \u0648\u0627\u0642\u0639 \u0645\u0631\u0627\u0645<\/h2>\n<div class=\"wp-block-group\" style=\"border-left-color:#3b82f6;border-left-width:5px;background-color:#eff6ff;padding:16px 18px\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\"><p><strong>\u0645\u0646 \u0648\u0627\u0642\u0639 \u0645\u0631\u0627\u0645:<\/strong> \u0639\u0644\u0649 \u062e\u0637\u0629 \u0628\u0623\u0631\u0628\u0639 \u0623\u0646\u0648\u064a\u0629 \u0648\u0630\u0627\u0643\u0631\u0629 7.8 \u062c\u064a\u062c\u0627\u0628\u0627\u064a\u062a \u0648\u062a\u062e\u0632\u064a\u0646 SSD\u060c \u0631\u0641\u0639 \u0636\u0628\u0637 PostgreSQL \u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u062a\u0642\u0627\u0631\u064a\u0631 Odoo \u0628\u0646\u062d\u0648 \u0627\u0644\u0631\u064f\u0628\u0639 \u062f\u0648\u0646 \u0623\u064a \u062a\u0631\u0642\u064a\u0629 \u0639\u062a\u0627\u062f. \u0648\u0645\u0639 \u0646\u0645\u0648 \u0639\u062f\u062f \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646\u060c \u0643\u0627\u0646\u062a \u0627\u0644\u062a\u0631\u0642\u064a\u0629 \u0625\u0644\u0649 \u0623\u0646\u0648\u064a\u0629 \u0623\u0643\u062b\u0631 \u0647\u064a \u0627\u0644\u062d\u0644 \u0627\u0644\u0623\u0646\u062c\u0639 \u0625\u0644\u0649 \u062c\u0627\u0646\u0628 \u0627\u0644\u0636\u0628\u0637. \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u062a\u0639\u062a\u0645\u062f \u0639\u0644\u0649 \u0628\u064a\u0627\u0646\u0627\u062a\u0643 \u0648\u0646\u0645\u0637 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0643 \u2014 \u0648\u0627\u0644\u0642\u064a\u0627\u0633 \u0639\u0644\u0649 \u0628\u064a\u0626\u062a\u0643 \u0647\u0648 \u0627\u0644\u0645\u0631\u062c\u0639.<\/p><\/div><\/div>\n<h2 class=\"wp-block-heading\" id=\"steps\">\u062e\u0637\u0648\u0627\u062a \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u0639\u0644\u0649 \u062e\u0627\u062f\u0645\u0643<\/h2>\n<p>\u0625\u0630\u0627 \u0623\u0631\u062f\u062a \u062a\u0637\u0628\u064a\u0642 <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u0639\u0644\u0649 \u062e\u0627\u062f\u0645\u0643 \u0628\u0646\u0641\u0633\u0643\u060c \u0627\u062a\u0628\u0639 \u0647\u0630\u0627 \u0627\u0644\u062a\u0633\u0644\u0633\u0644 \u0627\u0644\u0622\u0645\u0646:<\/p>\n<ol class=\"wp-block-list\"><li>\u062e\u0630 \u0646\u0633\u062e\u0629 \u0627\u062d\u062a\u064a\u0627\u0637\u064a\u0629 \u0643\u0627\u0645\u0644\u0629\u060c \u062b\u0645 \u0642\u0650\u0633 \u062e\u0637 \u0627\u0644\u0623\u0633\u0627\u0633 \u0628\u0640 <code>pgbench<\/code> \u0648<code>EXPLAIN (ANALYZE, BUFFERS)<\/code> \u0642\u0628\u0644 \u0623\u064a \u062a\u063a\u064a\u064a\u0631.<\/li><li>\u0627\u0636\u0628\u0637 <code>shared_buffers<\/code> \u0625\u0644\u0649 \u0646\u062d\u0648 25% \u0645\u0646 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0648<code>effective_cache_size<\/code> \u0625\u0644\u0649 \u0646\u062d\u0648 70%.<\/li><li>\u0627\u0631\u0641\u0639 <code>work_mem<\/code> \u0648<code>maintenance_work_mem<\/code> \u0628\u0627\u0639\u062a\u062f\u0627\u0644 \u062d\u0633\u0628 \u0639\u062f\u062f \u0627\u0644\u0627\u062a\u0635\u0627\u0644\u0627\u062a \u0627\u0644\u0645\u062a\u0648\u0642\u0639\u0629.<\/li><li>\u0639\u064a\u0651\u0646 <code>random_page_cost=1.1<\/code> \u0648<code>effective_io_concurrency=200<\/code> \u0625\u0646 \u0643\u0627\u0646 \u062a\u062e\u0632\u064a\u0646\u0643 SSD \u0623\u0648 NVMe.<\/li><li>\u0641\u0639\u0651\u0644 \u0627\u0644\u062a\u0648\u0627\u0632\u064a \u0628\u0645\u0627 \u064a\u0646\u0627\u0633\u0628 \u0639\u062f\u062f \u0627\u0644\u0623\u0646\u0648\u064a\u0629\u060c \u0648\u0639\u0637\u0651\u0644 <code>jit<\/code> \u0625\u0646 \u063a\u0644\u0628\u062a \u0639\u0644\u0649 \u0639\u0645\u0644\u0643 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0642\u0635\u064a\u0631\u0629 \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629.<\/li><li>\u0623\u0639\u062f \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u062e\u062f\u0645\u0629\u060c \u0634\u063a\u0651\u0644 <code>VACUUM ANALYZE<\/code>\u060c \u062b\u0645 \u0623\u0639\u062f \u0627\u0644\u0642\u064a\u0627\u0633 \u0648\u0642\u0627\u0631\u0646 \u0628\u062e\u0637 \u0627\u0644\u0623\u0633\u0627\u0633.<\/li><\/ol>\n<p>\u0648\u0625\u0646 \u0623\u0631\u062f\u062a \u0637\u0628\u0642\u0629 \u0623\u0639\u0645\u0642 \u0645\u0646 \u0627\u0644\u062a\u0641\u0627\u0635\u064a\u0644 \u062d\u0648\u0644 \u0643\u0644 \u0625\u0639\u062f\u0627\u062f\u060c \u0631\u0627\u062c\u0639 \u062f\u0644\u064a\u0644\u0646\u0627 \u0627\u0644\u0645\u062e\u0635\u0635: <a href=\"https:\/\/maram.iq\/blogs\/%d8%aa%d8%ad%d8%b3%d9%8a%d9%86-%d8%a3%d8%af%d8%a7%d8%a1-postgresql-12-%d8%a5%d8%b9%d8%af%d8%a7%d8%af-%d9%84%d8%aa%d8%b3%d8%b1%d9%8a%d8%b9-%d9%82%d8%a7%d8%b9%d8%af%d8%a9-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7\/\">\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 PostgreSQL: 12 \u0625\u0639\u062f\u0627\u062f \u0644\u062a\u0633\u0631\u064a\u0639 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a\u0643<\/a>\u060c \u0648\u0644\u062a\u0642\u062f\u064a\u0631 \u062d\u062c\u0645 \u0627\u0644\u062e\u0627\u062f\u0645 \u0627\u0644\u0645\u0646\u0627\u0633\u0628 \u0644\u0639\u062f\u062f \u0645\u0633\u062a\u062e\u062f\u0645\u064a Odoo \u0631\u0627\u062c\u0639 <a href=\"https:\/\/maram.iq\/blogs\/odoo-architecture-sizing\/\">\u0628\u0646\u064a\u0629 Odoo \u0644\u0640100 \u0648500 \u06481500 \u0645\u0633\u062a\u062e\u062f\u0645<\/a>. \u0627\u0644\u0645\u0631\u062c\u0639\u0627\u0646 \u0627\u0644\u0631\u0633\u0645\u064a\u0627\u0646 \u0627\u0644\u0645\u0641\u064a\u062f\u0627\u0646 \u0647\u0646\u0627 \u0647\u0645\u0627 <a href=\"https:\/\/www.postgresql.org\/docs\/current\/runtime-config-resource.html\" target=\"_blank\" rel=\"noopener\">\u062a\u0648\u062b\u064a\u0642 \u0645\u0648\u0627\u0631\u062f PostgreSQL<\/a> \u0648<a href=\"https:\/\/www.odoo.com\/documentation\/18.0\/administration\/on_premise\/deploy.html\" target=\"_blank\" rel=\"noopener\">\u062f\u0644\u064a\u0644 \u0646\u0634\u0631 Odoo \u0627\u0644\u0631\u0633\u0645\u064a<\/a>.<\/p>\n<h2 class=\"wp-block-heading\" id=\"faq\">\u0627\u0644\u0623\u0633\u0626\u0644\u0629 \u0627\u0644\u0634\u0627\u0626\u0639\u0629<\/h2>\n<h3 class=\"wp-block-heading\">\u0647\u0644 \u064a\u062a\u0637\u0644\u0628 \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u0639\u062a\u0627\u062f\u061f<\/h3>\n<p>\u0644\u0627 \u0628\u0627\u0644\u0636\u0631\u0648\u0631\u0629. \u0641\u064a \u0627\u062e\u062a\u0628\u0627\u0631\u0646\u0627 \u062e\u0641\u0651\u0636 \u0636\u0628\u0637 PostgreSQL \u0648\u062d\u062f\u0647 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0628\u0646\u062d\u0648 20% \u0648\u0631\u0641\u0639 \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0646\u062d\u0648 24% \u062f\u0648\u0646 \u0623\u064a \u062a\u063a\u064a\u064a\u0631 \u0641\u064a \u0627\u0644\u0639\u062a\u0627\u062f. \u0627\u0644\u062a\u0631\u0642\u064a\u0629 \u062a\u0635\u0628\u062d \u0644\u0627\u0632\u0645\u0629 \u0641\u0642\u0637 \u0639\u0646\u062f \u0627\u0631\u062a\u0641\u0627\u0639 \u0639\u062f\u062f \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646.<\/p>\n<h3 class=\"wp-block-heading\">\u0645\u0627 \u0623\u0647\u0645 \u0625\u0639\u062f\u0627\u062f \u0641\u064a PostgreSQL \u0644\u0623\u062f\u0627\u0621 Odoo\u061f<\/h3>\n<p>\u0644\u0627 \u064a\u0648\u062c\u062f \u0625\u0639\u062f\u0627\u062f \u0633\u062d\u0631\u064a \u0648\u0627\u062d\u062f\u061b \u0627\u0644\u062a\u0623\u062b\u064a\u0631 \u0627\u0644\u0623\u0643\u0628\u0631 \u062c\u0627\u0621 \u0645\u0646 \u0645\u062c\u0645\u0648\u0639\u0629: shared_buffers \u0648effective_cache_size \u0648work_mem \u0648\u062a\u0639\u0637\u064a\u0644 jit\u060c \u0645\u0639 random_page_cost \u0645\u0646\u0627\u0633\u0628 \u0644\u0644\u062a\u062e\u0632\u064a\u0646. \u0627\u0644\u0642\u064a\u0645 \u062a\u064f\u0634\u062a\u0642 \u0645\u0646 \u062d\u062c\u0645 \u0630\u0627\u0643\u0631\u0629 \u0627\u0644\u062e\u0627\u062f\u0645 \u0648\u0646\u0648\u0639 \u062a\u062e\u0632\u064a\u0646\u0647.<\/p>\n<h3 class=\"wp-block-heading\">\u0644\u0645\u0627\u0630\u0627 \u0644\u0645 \u064a\u062a\u062d\u0633\u0651\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u062a\u062d\u062a \u0627\u0644\u062d\u0650\u0645\u0644 \u0627\u0644\u0639\u0627\u0644\u064a\u061f<\/h3>\n<p>\u0644\u0623\u0646 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u0643\u0627\u0646 \u0627\u0644\u0633\u0642\u0641. \u0645\u0639 \u0623\u0631\u0628\u0639\u0629 \u0639\u0645\u0644\u0627\u0621 \u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646 \u0639\u0644\u0649 \u0623\u0631\u0628\u0639 \u0623\u0646\u0648\u064a\u0629\u060c \u064a\u064f\u0634\u0628\u0639 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u0648\u0644\u0627 \u064a\u0636\u064a\u0641 \u0627\u0644\u0636\u0628\u0637 \u0623\u0646\u0648\u064a\u0629. \u062e\u062f\u0645\u0629 \u062a\u0632\u0627\u0645\u0646 \u0623\u0639\u0644\u0649 \u062a\u062a\u0637\u0644\u0628 \u0632\u064a\u0627\u062f\u0629 \u0639\u062f\u062f \u0627\u0644\u0623\u0646\u0648\u064a\u0629 \u0639\u0628\u0631 \u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u062e\u0637\u0629.<\/p>\n<h3 class=\"wp-block-heading\">\u0647\u0644 work_mem \u064a\u0635\u0646\u0639 \u0641\u0631\u0642\u064b\u0627 \u062f\u0627\u0626\u0645\u064b\u0627\u061f<\/h3>\n<p>\u0644\u064a\u0633 \u062f\u0627\u0626\u0645\u064b\u0627. \u0639\u0644\u0649 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0633\u0631\u064a\u0639 (SSD\/NVMe) \u0643\u0627\u0646 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 \u0627\u0644\u0641\u0631\u0632 \u0639\u0644\u0649 \u0627\u0644\u0642\u0631\u0635 \u0648\u0627\u0644\u0641\u0631\u0632 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0636\u0626\u064a\u0644\u064b\u0627 \u0641\u064a \u0627\u062e\u062a\u0628\u0627\u0631\u0646\u0627. \u064a\u0638\u0647\u0631 \u0623\u062b\u0631 work_mem \u0628\u0648\u0636\u0648\u062d \u0623\u0643\u0628\u0631 \u0639\u0644\u0649 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0628\u0637\u064a\u0621 \u0623\u0648 \u0645\u0639 \u0639\u0645\u0644\u064a\u0627\u062a \u0641\u0631\u0632 \u0623\u0636\u062e\u0645 \u0628\u0643\u062b\u064a\u0631.<\/p>\n<h3 class=\"wp-block-heading\">\u0643\u0644 \u0643\u0645 \u064a\u0646\u0628\u063a\u064a \u0625\u0639\u0627\u062f\u0629 \u0636\u0628\u0637 PostgreSQL\u061f<\/h3>\n<p>\u0639\u0646\u062f \u062a\u063a\u064a\u0651\u0631 \u062d\u062c\u0645 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0623\u0648 \u0627\u0644\u062e\u0637\u0629\u060c \u0623\u0648 \u0639\u0646\u062f \u0646\u0645\u0648 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0643\u0628\u064a\u0631. \u0631\u0627\u0642\u0628 pg_stat_statements \u0644\u0631\u0635\u062f \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629 \u0648\u0623\u0639\u062f \u0627\u0644\u062a\u0642\u064a\u064a\u0645 \u062f\u0648\u0631\u064a\u064b\u0627.<\/p>\n<h2 class=\"wp-block-heading\" id=\"end\">\u0627\u0644\u062e\u0644\u0627\u0635\u0629<\/h2>\n<p>\u0623\u062b\u0628\u062a\u062a \u0627\u0644\u0623\u0631\u0642\u0627\u0645 \u0627\u0644\u062d\u0642\u064a\u0642\u064a\u0629 \u0623\u0646 <strong>\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo<\/strong> \u0644\u0627 \u064a\u0628\u062f\u0623 \u062f\u0627\u0626\u0645\u064b\u0627 \u0628\u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u0639\u062a\u0627\u062f\u060c \u0628\u0644 \u0628\u0636\u0628\u0637 PostgreSQL \u0636\u0628\u0637\u064b\u0627 \u064a\u0646\u0627\u0633\u0628 \u062e\u0627\u062f\u0645\u0643 \u2014 \u0648\u0647\u0648 \u0645\u0627 \u0645\u0646\u062d\u0646\u0627 \u0634\u0627\u0634\u0627\u062a \u062a\u0642\u0627\u0631\u064a\u0631 \u0623\u0633\u0631\u0639 \u0628\u0646\u062d\u0648 \u0627\u0644\u062e\u064f\u0645\u0633 \u0645\u062c\u0627\u0646\u064b\u0627. \u0627\u0644\u0636\u0628\u0637 \u0627\u0644\u062c\u064a\u062f \u064a\u0631\u0641\u0639 \u0633\u0642\u0641 \u0643\u0644 \u062e\u0627\u062f\u0645\u060c \u0648\u0627\u0644\u062a\u0631\u0642\u064a\u0629 \u062a\u0631\u0641\u0639 \u0633\u0642\u0641 \u0627\u0644\u062a\u0632\u0627\u0645\u0646\u061b \u0645\u0639\u064b\u0627 \u064a\u0645\u0646\u062d\u0627\u0646 \u062a\u062c\u0631\u0628\u0629 Odoo \u0633\u0631\u064a\u0639\u0629 \u0648\u0645\u0633\u062a\u0642\u0631\u0629. \u0641\u064a \u0645\u0631\u0627\u0645 \u0646\u0648\u0641\u0651\u0631 \u0628\u0646\u064a\u0629 \u062a\u062d\u062a\u064a\u0629 \u0633\u0631\u064a\u0639\u0629 \u0648\u0636\u0628\u0637\u064b\u0627 \u0627\u062d\u062a\u0631\u0627\u0641\u064a\u064b\u0627 \u064a\u062c\u0639\u0644 \u0630\u0644\u0643 \u062c\u0627\u0647\u0632\u064b\u0627 \u0645\u0646 \u0627\u0644\u064a\u0648\u0645 \u0627\u0644\u0623\u0648\u0644.<\/p>\n<p class=\"has-text-align-center\"><a href=\"https:\/\/maram.iq\/Odoo-high-performance\" style=\"background:#16a34a;color:#fff;font-weight:700;padding:12px 28px;border-radius:8px;text-decoration:none\">\u0627\u0633\u062a\u0636\u0641 Odoo \u0639\u0644\u0649 \u0628\u0646\u064a\u0629 \u0633\u0631\u064a\u0639\u0629 \u0648\u0645\u0636\u0628\u0648\u0637\u0629<\/a><\/p>\n\n<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"\u0647\u0644 \u064a\u062a\u0637\u0644\u0628 \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u0639\u062a\u0627\u062f\u061f\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0644\u0627 \u0628\u0627\u0644\u0636\u0631\u0648\u0631\u0629. \u0641\u064a \u0627\u062e\u062a\u0628\u0627\u0631\u0646\u0627 \u062e\u0641\u0651\u0636 \u0636\u0628\u0637 PostgreSQL \u0648\u062d\u062f\u0647 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645 \u0628\u0646\u062d\u0648 20% \u0648\u0631\u0641\u0639 \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0646\u062d\u0648 24% \u062f\u0648\u0646 \u0623\u064a \u062a\u063a\u064a\u064a\u0631 \u0641\u064a \u0627\u0644\u0639\u062a\u0627\u062f. \u0627\u0644\u062a\u0631\u0642\u064a\u0629 \u062a\u0635\u0628\u062d \u0644\u0627\u0632\u0645\u0629 \u0641\u0642\u0637 \u0639\u0646\u062f \u0627\u0631\u062a\u0641\u0627\u0639 \u0639\u062f\u062f \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u0627\u0644\u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646.\"}},{\"@type\":\"Question\",\"name\":\"\u0645\u0627 \u0623\u0647\u0645 \u0625\u0639\u062f\u0627\u062f \u0641\u064a PostgreSQL \u0644\u0623\u062f\u0627\u0621 Odoo\u061f\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0644\u0627 \u064a\u0648\u062c\u062f \u0625\u0639\u062f\u0627\u062f \u0633\u062d\u0631\u064a \u0648\u0627\u062d\u062f\u061b \u0627\u0644\u062a\u0623\u062b\u064a\u0631 \u0627\u0644\u0623\u0643\u0628\u0631 \u062c\u0627\u0621 \u0645\u0646 \u0645\u062c\u0645\u0648\u0639\u0629: shared_buffers \u0648effective_cache_size \u0648work_mem \u0648\u062a\u0639\u0637\u064a\u0644 jit\u060c \u0645\u0639 random_page_cost \u0645\u0646\u0627\u0633\u0628 \u0644\u0644\u062a\u062e\u0632\u064a\u0646. \u0627\u0644\u0642\u064a\u0645 \u062a\u064f\u0634\u062a\u0642 \u0645\u0646 \u062d\u062c\u0645 \u0630\u0627\u0643\u0631\u0629 \u0627\u0644\u062e\u0627\u062f\u0645 \u0648\u0646\u0648\u0639 \u062a\u062e\u0632\u064a\u0646\u0647.\"}},{\"@type\":\"Question\",\"name\":\"\u0644\u0645\u0627\u0630\u0627 \u0644\u0645 \u064a\u062a\u062d\u0633\u0651\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u062a\u062d\u062a \u0627\u0644\u062d\u0650\u0645\u0644 \u0627\u0644\u0639\u0627\u0644\u064a\u061f\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0644\u0623\u0646 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u0643\u0627\u0646 \u0627\u0644\u0633\u0642\u0641. \u0645\u0639 \u0623\u0631\u0628\u0639\u0629 \u0639\u0645\u0644\u0627\u0621 \u0645\u062a\u0632\u0627\u0645\u0646\u064a\u0646 \u0639\u0644\u0649 \u0623\u0631\u0628\u0639 \u0623\u0646\u0648\u064a\u0629\u060c \u064a\u064f\u0634\u0628\u0639 \u0627\u0644\u0645\u0639\u0627\u0644\u062c \u0648\u0644\u0627 \u064a\u0636\u064a\u0641 \u0627\u0644\u0636\u0628\u0637 \u0623\u0646\u0648\u064a\u0629. \u062e\u062f\u0645\u0629 \u062a\u0632\u0627\u0645\u0646 \u0623\u0639\u0644\u0649 \u062a\u062a\u0637\u0644\u0628 \u0632\u064a\u0627\u062f\u0629 \u0639\u062f\u062f \u0627\u0644\u0623\u0646\u0648\u064a\u0629 \u0639\u0628\u0631 \u062a\u0631\u0642\u064a\u0629 \u0627\u0644\u062e\u0637\u0629.\"}},{\"@type\":\"Question\",\"name\":\"\u0647\u0644 work_mem \u064a\u0635\u0646\u0639 \u0641\u0631\u0642\u064b\u0627 \u062f\u0627\u0626\u0645\u064b\u0627\u061f\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0644\u064a\u0633 \u062f\u0627\u0626\u0645\u064b\u0627. \u0639\u0644\u0649 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0633\u0631\u064a\u0639 (SSD\/NVMe) \u0643\u0627\u0646 \u0627\u0644\u0641\u0631\u0642 \u0628\u064a\u0646 \u0627\u0644\u0641\u0631\u0632 \u0639\u0644\u0649 \u0627\u0644\u0642\u0631\u0635 \u0648\u0627\u0644\u0641\u0631\u0632 \u0641\u064a \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0636\u0626\u064a\u0644\u064b\u0627 \u0641\u064a \u0627\u062e\u062a\u0628\u0627\u0631\u0646\u0627. \u064a\u0638\u0647\u0631 \u0623\u062b\u0631 work_mem \u0628\u0648\u0636\u0648\u062d \u0623\u0643\u0628\u0631 \u0639\u0644\u0649 \u0627\u0644\u062a\u062e\u0632\u064a\u0646 \u0627\u0644\u0628\u0637\u064a\u0621 \u0623\u0648 \u0645\u0639 \u0639\u0645\u0644\u064a\u0627\u062a \u0641\u0631\u0632 \u0623\u0636\u062e\u0645 \u0628\u0643\u062b\u064a\u0631.\"}},{\"@type\":\"Question\",\"name\":\"\u0643\u0644 \u0643\u0645 \u064a\u0646\u0628\u063a\u064a \u0625\u0639\u0627\u062f\u0629 \u0636\u0628\u0637 PostgreSQL\u061f\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\u0639\u0646\u062f \u062a\u063a\u064a\u0651\u0631 \u062d\u062c\u0645 \u0627\u0644\u0630\u0627\u0643\u0631\u0629 \u0623\u0648 \u0627\u0644\u062e\u0637\u0629\u060c \u0623\u0648 \u0639\u0646\u062f \u0646\u0645\u0648 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0643\u0628\u064a\u0631. \u0631\u0627\u0642\u0628 pg_stat_statements \u0644\u0631\u0635\u062f \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0627\u0644\u0628\u0637\u064a\u0626\u0629 \u0648\u0623\u0639\u062f \u0627\u0644\u062a\u0642\u064a\u064a\u0645 \u062f\u0648\u0631\u064a\u064b\u0627.\"}}]}<\/script>","protected":false},"excerpt":{"rendered":"<p>\u0639\u0646\u062f\u0645\u0627 \u064a\u0634\u0643\u0648 \u0645\u0633\u062a\u062e\u062f\u0645\u0648 \u0646\u0638\u0627\u0645 Odoo \u0645\u0646 \u0628\u0637\u0621 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u0634\u0627\u0634\u0627\u062a \u0627\u0644\u0642\u0648\u0627\u0626\u0645\u060c \u064a\u0643\u0648\u0646 \u0627\u0644\u0633\u0628\u0628 \u063a\u0627\u0644\u0628\u064b\u0627 \u0641\u064a \u0637\u0628\u0642\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0627 \u0641\u064a \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0646\u0641\u0633\u0647. \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 Odoo \u064a\u0628\u062f\u0623 \u0645\u0646 \u0636\u0628\u0637 PostgreSQL \u2014 \u0642\u0627\u0639\u062f\u0629&#8230;<\/p>\n","protected":false},"author":6,"featured_media":5676,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[866,894],"tags":[154,164,155,158,140,157],"class_list":["post-5672","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-performance-benchmarks","category-case-studies","tag-nvme","tag-odoo","tag-ssd","tag-158","tag-140","tag-157"],"_links":{"self":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/5672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/comments?post=5672"}],"version-history":[{"count":3,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/5672\/revisions"}],"predecessor-version":[{"id":5675,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/posts\/5672\/revisions\/5675"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/media\/5676"}],"wp:attachment":[{"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/media?parent=5672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/categories?post=5672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maram.iq\/blogs\/wp-json\/wp\/v2\/tags?post=5672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}