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

Powiązane posty	Odpowiedzi	Widoki
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users performance postgresql workers tuning odoo	0 mar 24	2448
Asset Report timeout performance postgresql reporting timeout assets	0 cze 22	2401
Odoo Performance Issue performance postgresql odoo	0 sty 17	4454
How to improve postgres performance in Odoo9 performance server postgresql cpu odoo9	0 paź 24	1482
How to design architecture for large system as saas? performance postgresql saas architecture v14	0 mar 22	3951

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!