11
votes
3answers
4k views

kill -9 a postgres process

A postgres SELECT query ran out of control on our DB server and started eating up tons of memory and swap until the server ran out of memory. I found the particular process via ps aux | grep postgres ...
0
votes
2answers
613 views

PostgreSQL processes and the signals to which they respond

For PostgreSQL 8.3 and later, what are the processes that make up the server and that respond to a query? What signals do the various processes respond to and what effect do the signals have? What ...