P
P
Puma Thailand2016-02-02 13:26:55
PostgreSQL
Puma Thailand, 2016-02-02 13:26:55

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

1 answer(s)
A
Andrey Burov, 2016-02-02
@BuriK666

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 question

Ask a Question

731 491 924 answers to any question