Hello, I just installed SquashTM and Postgre in a 4 CPU VM; I made some tests, and it works.
Then I added 21 test cases to an execution plan and tried testing it: all became incredibly slow.
I looked at the system, and found that when it is stuck, the situation is as in the picture: Postgre is consuming a CPU for minutes with status "idle" (or "SELECT", sometimes).
What should I do to fix it?
Thank you!
Postgre consuming CPU for minutes
Postgre consuming CPU for minutes
- Pièces jointes
-
- Screenshot 2021-01-25 102233.jpg (49.02 Kio) Consulté 908 fois
Re: Postgre consuming CPU for minutes
I solved!!
First: I needed to run the analyze command; secondo I had to turn Jit off.
The slow query was 6seconds, then 235ms and now it is 0.84ms!!!
First: I needed to run the analyze command; secondo I had to turn Jit off.
The slow query was 6seconds, then 235ms and now it is 0.84ms!!!