Hi,
On some corner cases our database servers starts to use from swap space
and that totally makes PostgreSQL (or any other I/O bound application)
to fall upon its knees. In our current structure, responsiveness has the
highest priority and thus it is ok for us to cancel queries at that
instant and re-initiate connections. To achieve this effect, I started
to turn swap space off on some of the servers and turned
vm.oom_kill_allocating_task kernel parameter on. (Periodical postgres
process availability checks decides whether there is a need to fire up a
fresh postgres instance.) So far, this method worked pretty well but I'm
suspicious about data corruptions. (Disks configurations are set to RAID
10.) What are the downsides of such a design scheme?
Regards.