Re: 7.3.4 freezing

On Wed, 28 Jan 2004, MaRCeLO PeReiRA wrote:

> 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!! :(

Dang.  When you run top, what do the postgres owned processes show?