Comment 12 for bug 709575

Revision history for this message
xrg (xrg) wrote : Re: [Bug 709575] Re: [6.0.1][stock] very very slow (22 minutes!!!) to process a large picking

On Monday 31 January 2011, you wrote:
> Olivier,
>
> I'll look at that perf to see if I can do something. Already, I can tell
> you that there isn't any very very slow queries. Instead, it looks, the
> 20 minutes to process our 315 items pickings is made out of a lot of lot
> of small ~150 ms queries + Python processing (although as I said, a top
> shows that Potgres is eating 70% of the CPU, Python 30%).
>
> I should still analyse the log, but that's of any help, I'm attaching a
> log of the SQL requests longer than 100 ms during this process.
>
> ** Attachment added: "postgresql-2011-01-29_230423.log"

Please, can you try the attached patch?
It seems to improve things for /one/ case so far.