Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group