Postgres Pro
Downloads
Home   >   mailing lists

Re: DB Restart - Mailing list pgsql-general

From Sam Jas
Subject Re: DB Restart
Date
Msg-id 235599.38592.qm@web95010.mail.in2.yahoo.com
Whole thread Raw
In response to Re: DB Restart  (Richard Huxton <dev@archonet.com>)
Responses Re: DB Restart  (Richard Huxton <dev@archonet.com>)
Re: DB Restart  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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@archonet.com> wrote:


From: Richard Huxton <dev@archonet.com>
Subject: Re: [GENERAL] DB Restart
To: "Sam Jas" <samjas33@yahoo.com>
Cc: "general" <pgsql-general@postgresql.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@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.

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: [pgeu-general] pgday.eu
Next
From: Michael Nacos
Date:
Subject: Re: What is the simpliest text search configuration?