Skip to Content
Dette spørgsmål er blevet anmeldt
performancepostgresqlreportingtuning
2 Besvarelser
6673 Visninger
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
Kassér
Avatar
TidyWay Software Solutions, TidyWay
Bedste svar

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
Kassér
Avatar
Qutechs, Ahmed M.Elmubarak
Bedste svar

Hello,

You can check this question, it may helps

Thanx

Avatar
Kassér
Relaterede indlæg Besvarelser Visninger Aktivitet
Have You Manually Tuned PostgreSQL for Better Odoo Performance?
configuration performance postgresql tuning Solutions
Avatar
0
apr. 26
591
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users
performance postgresql workers tuning odoo
Avatar
0
mar. 24
6570
Asset Report timeout
performance postgresql reporting timeout assets
Avatar
0
jun. 22
3702
Odoo Performance Issue
performance postgresql odoo
Avatar
0
jan. 17
6323
Odoo Performance Discussion: Slow Deletes on Large Relational Models
performance postgresql postgres odoo
Avatar
Avatar
Avatar
Avatar
4
maj 26
1416