Re: 7.3.4 freezing - Mailing list pgsql-general

From MaRCeLO PeReiRA
Subject Re: 7.3.4 freezing
Date
Msg-id 20040128184457.32718.qmail@web20208.mail.yahoo.com
Whole thread Raw
In response to Re: 7.3.4 freezing  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: 7.3.4 freezing  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: 7.3.4 freezing  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 7.3.4 freezing  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Hi,


> Is the machine becoming unresponsive?  I.e. is it
> taking several seconds
> for things like ls to run?

It isn't the case! I can do everything without
problem, and without losing performance. The main
problem is the postmaster daemon, that die. (really
;-)

> What does top show for postgresql memory and cpu
> usage?

The top output is something like this:

top - 16:44:24 up 2 days,  6:15, 10 users,  load
average: 1.24, 1.16, 1.05
Tasks: 123 total,   4 running, 119 sleeping,   0
stopped,   0 zombie
Cpu(s):  96.0% user,   4.0% system,   0.0% nice,
0.0% idle
Mem:    256292k total,   243696k used,    12596k free,
   14024k buffers
Swap:   530104k total,    82568k used,   447536k free,
  114312k cached

> Is postgresql really freezing, or just running
> REALLY slow?  I.e.
> sometimes if you wait long enough you can get in to
> what seems to be a
> frozen database

No way! It really die!! :(

Regards,

Marcelo

______________________________________________________________________

Yahoo! GeoCities: a maneira mais fácil de criar seu web site grátis!
http://br.geocities.yahoo.com/

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: 7.3.4 freezing
Next
From:
Date:
Subject: Single step Sql script GUI editor