Answer the question
In order to leave comments, you need to log in
Why are there blunts with a large number of inserts in postgresql?
There is a large server with 64 gigabytes of
RAM
and ssd disks, the server is not overloaded with a load average of a little more than
1.
Postgresql
9.4
is
running
on
it
. = 16MB
default_statistics_target = 100
From time to time, when pasting, there is a blunt for 1-5 seconds, which is fatal of course.
There are many insertions, hundreds per parallel per second.
Answer the question
In order to leave comments, you need to log in
If possible, do batch inserts (using transactions)
Remove unnecessary indexes (they slow down the insert a lot)
Turn off fsync - (at your own risk)
https://vimeo.com/123424249
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question