Sam Jas wrote: > 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
Well, this process won't respond to pg_cancel_backend() because it's not a normal backend. It's the background-writer process. Do you see the same problem with ordinary backend processes, or is it always the writer? Also - are you familiar with "strace"? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
