Skip ke Konten
Pertanyaan ini telah diberikan tanda
performancepostgresqlreportingtuning
2 Replies
5365 Tampilan
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
Buang
Avatar
TidyWay
Jawaban Terbai

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
Buang
Avatar
Qutechs, Ahmed M.Elmubarak
Jawaban Terbai

Hello,

You can check this question, it may helps

Thanx

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
Seeking Odoo Server Performance configuration/ advice / tips / benchmarks for 60 concurrent users
performance postgresql workers tuning odoo
Avatar
0
Mar 24
4291
Asset Report timeout
performance postgresql reporting timeout assets
Avatar
0
Jun 22
2945
Odoo Performance Issue
performance postgresql odoo
Avatar
0
Jan 17
5132
How to improve postgres performance in Odoo9
performance server postgresql cpu odoo9
Avatar
0
Okt 24
2250
How to design architecture for large system as saas?
performance postgresql saas architecture v14
Avatar
0
Mar 22
4738