Odoo Help


high volume of data failed to generate report

Akhmad Daniel Sembiring
on 3/12/14, 7:20 AM 2,084 views

hi All,

Currently we have around 350,000 lines of account_move_line and 60,000 lines of account_move, and it;s increasing shortly. Those records belongs to a single partner.

my OpenERP system was failed just to generate "General Ledger" and "Partner Ledger" report from all those records. the browser is just displaying loading message with no end. All other simple reports with only few pages of PDF are fine.

my server has 6GB of RAM, 12 cores CPU, running CentOS 6 linux.

i have done openerp, postgresql and linux kernel tuning as follows:


kernel.shmmax = 68719476739 kernel.shmall = 16777216 kernel.shmmni = 4096


shared_buffers = 4GB
temp_buffers = 500MB default_statistics_target = 100 maintenance_work_mem = 480MB checkpoint_completion_target = 0.9 effective_cache_size = 6GB work_mem = 50MB wal_buffers = 16MB checkpoint_segments = 64


workers = 25 limit_request = 100000 osv_memory_age_limit = 1.0 limit_time_real = 240 limit_time_cpu = 600 limit_memory_hard = 6442450944 limit_memory_soft = 3221225472

but still no luck generating those reports. any help or clue will be very appreciated


Mind And Go
On 2/6/16, 8:53 AM


your limit_memory are too low for so much workers. I've already had this issue.

Try to multiply per 10 to see what's going on.


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 3/12/14, 7:20 AM
Seen: 2084 times
Last updated: 2/6/16, 8:53 AM