On Tue, Jul 18, 2017 at 1:01 PM, Claudio Freire <klaussfreire@gmail.com> wrote: > On Tue, Jul 18, 2017 at 6:20 AM, Charles Nadeau > <charles.nadeau@gmail.com> wrote: >> Claudio, >> >> At one moment >> during the query, there is a write storm to the swap drive (a bit like this >> case: >> https://www.postgresql.org/message-id/AANLkTi%3Diw4fC2RgTxhw0aGpyXANhOT%3DXBnjLU1_v6PdA%40mail.gmail.com). >> I can hardly explain it as there is plenty of memory on this server. > > That sounds a lot like NUMA zone_reclaim issues: > > https://www.postgresql.org/message-id/500616CB.3070408@2ndQuadrant.com I realize you have zone_reclaim_mode set to 0. Still, the symptoms are eerily similar.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных