Re: 7.3.4 freezing

From: MaRCeLO PeReiRA <gandalf_mp(at)yahoo(dot)com(dot)br>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: 7.3.4 freezing
Date: 2004-01-28 18:44:57
Message-ID: 20040128184457.32718.qmail@web20208.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message lnd 2004-01-28 18:47:24 Single step Sql script GUI editor
Previous Message scott.marlowe 2004-01-28 18:29:20 Re: 7.3.4 freezing