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 Software Solutions, 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

Relaterade inlägg	Svar	Vyer
Have You Manually Tuned PostgreSQL for Better Odoo Performance? configuration performance postgresql tuning Solutions	0 apr. 26	690
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users performance postgresql workers tuning odoo	0 mars 24	6689
Asset Report timeout performance postgresql reporting timeout assets	0 juni 22	3758
Odoo Performance Issue performance postgresql odoo	0 jan. 17	6383
Odoo Performance Discussion: Slow Deletes on Large Relational Models performance postgresql postgres odoo	4 maj 26	1529

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!