We are running on 64 - bit. Whenever the reserved memory in top command it crosses 3.9g it hangs. If we try to kill process (using pg_cancel_backend()) it won't kill. At last either we have to kill all process at OS level or we have to reboot the server. After rebooting server everything worked perfectly fine. BTW we are using postgreSQL 8.3.2.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4822 postgres 15 0 4045m 3.8g 3.8g S 0.7 12.1 2:09.63 postgres: writer process Thanks Sam --- On Thu, 12/11/09, Richard Huxton <[email protected]> wrote: From: Richard Huxton <[email protected]> Subject: Re: [GENERAL] DB Restart To: "Sam Jas" <[email protected]> Cc: "general" <[email protected]> Date: Thursday, 12 November, 2009, 12:56 PM Sam Jas wrote: > Thanks for your reply. > > No we are not running OOM. ulimit o/p is as below. > > [postg...@server1 ~]$ ulimit > unlimited Unless you are running on a 32-bit system you should be alright then. What precisely is the problem? What do you mean by the DB "hangs"? -- Richard Huxton Archonet Ltd The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
