From: | Sam Jas <samjas33(at)yahoo(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: DB Restart |
Date: | 2009-11-12 13:16:57 |
Message-ID: | 235599.38592.qm@web95010.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <dev(at)archonet(dot)com> wrote:
From: Richard Huxton <dev(at)archonet(dot)com>
Subject: Re: [GENERAL] DB Restart
To: "Sam Jas" <samjas33(at)yahoo(dot)com>
Cc: "general" <pgsql-general(at)postgresql(dot)org>
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.
>
> [postgres(at)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Nacos | 2009-11-12 13:40:59 | Re: What is the simpliest text search configuration? |
Previous Message | Jérôme Etévé | 2009-11-12 13:05:38 | What is the simpliest text search configuration? |