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

Related Posts	Відповіді	Переглядів
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users performance postgresql workers tuning odoo	0 бер. 24	2588
Asset Report timeout performance postgresql reporting timeout assets	0 черв. 22	2463
Odoo Performance Issue performance postgresql odoo	0 січ. 17	4501
How to improve postgres performance in Odoo9 performance server postgresql cpu odoo9	0 жовт. 24	1532
How to design architecture for large system as saas? performance postgresql saas architecture v14	0 бер. 22	4030

Це запитання позначене

Enjoying the discussion? Don't just read, join in!