"Sally Sally" <dedeb17@xxxxxxxxxxx> writes: > Well after kill -9, it was in recovery mode but I restarted the server > again. It took a while (~ 45min) but it connected again. I have noticed that > after a vacuum it takes a while to connect for the first time. You mentioned > kill -9 is very bad news. Everything seems to be working fine now, should I > be worried? What are the consequences? The problem with kill -9 is mainly if you use it to kill the postmaster; then the postmaster is unable to release its shared memory segment before quitting. Depending on how your kernel handles shared memory, the segment might stick around indefinitely (unless manually cleaned up or you reboot the whole machine). This will eventually run the system out of memory and/or prevent launching a new postmaster. kill -9 on an individual backend isn't so dangerous, but it's still using a steam hammer to swat a fly. Try less invasive methods first, like kill -INT (ie, query cancel). BTW, the unreasonably long restart time suggests that you've set unreasonably long inter-checkpoint intervals. Might want to think about backing off the checkpoint parameters a bit. regards, tom lane
