Performance issue with reports (eg.stock valuatoin)

Question

When taking stock valuation reports with a more than 15000 records in Quants hitting my cpu usage to 90-95% by PostgreSQL.
I have tried manual PostgreSQL tuning an also with  pg_tune but the effect was same, the report is taking time to load.
PostgreSQL v9.3
DB-server configuration is Intel(R) Xeon(R) CPU E5-2650L v3 @ 1.80GHz x 8cpu  and have a 15GiB RAM..
anyone please suggest some ways to improve the performance in taking reports.

TidyWay · Answer

Hello,

This report will help you to print valuation on particular date with stock IN/OUT/ADJUSTMENT Quantities.
Navigate To : https://apps.odoo.com/apps/modules/11.0/stock_valuation_on_date/
For more information contact : tidyway.in@gmail.com

Thank you, Rohan

Qutechs, Ahmed M.Elmubarak · Answer

Hello,
You can check this question, [1]  it may helps
Thanx

[1] https://www.odoo.com/forum/help-1/question/reason-why-odoo-being-slow-when-there-is-huge-data-inside-the-database-87498

相關帖文	回覆	瀏覽次數
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users performance postgresql workers tuning odoo	0 3月 24	2511
Asset Report timeout performance postgresql reporting timeout assets	0 6月 22	2436
Odoo Performance Issue performance postgresql odoo	0 1月 17	4478
How to improve postgres performance in Odoo9 performance server postgresql cpu odoo9	0 10月 24	1509
How to design architecture for large system as saas? performance postgresql saas architecture v14	0 3月 22	4003

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！