On Tue, Jul 18, 2017 at 6:20 AM, Charles Nadeau <charles.nad...@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.3070...@2ndquadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
