Skip to Content
This question has been flagged
performancepostgresqlreportingtuning
2 Replies
5438 Zobrazenia
Avatar
Lithin T

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.

Avatar
Zrušiť
Avatar
TidyWay
Best 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

Avatar
Zrušiť
Avatar
Qutechs, Ahmed M.Elmubarak
Best Answer

Hello,

You can check this question, it may helps

Thanx

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users
performance postgresql workers tuning odoo
Avatar
0
mar 24
4500
Asset Report timeout
performance postgresql reporting timeout assets
Avatar
0
jún 22
2998
Odoo Performance Issue
performance postgresql odoo
Avatar
0
jan 17
5226
How to improve postgres performance in Odoo9
performance server postgresql cpu odoo9
Avatar
0
okt 24
2347
How to design architecture for large system as saas?
performance postgresql saas architecture v14
Avatar
0
mar 22
4803