Re: db restore eats too much memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: db restore eats too much memory
Date: 2005-04-12 14:09:01
Message-ID: 15394.1113314941@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tsirkin Evgeny <tsurkin(at)mail(dot)jct(dot)ac(dot)il> writes:
> top - 12:07:46 up 1:06, 2 users, load average: 0.99, 0.93, 0.57
> Tasks: 52 total, 3 running, 49 sleeping, 0 stopped, 0 zombie
> Cpu(s): 99.7% us, 0.3% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
> Mem: 1035532k total, 364012k used, 671520k free, 31292k buffers
> Swap: 2096472k total, 0k used, 2096472k free, 282468k cached

> this is not there but while machine is steel up i can see postmaster
> got 1.6 mem and 99.7% cpu.you can see also that the swap is realy big.

No, I can see that the swap isn't being touched at all ... and main
memory seems to have a lot of slop too. Whatever problem you may be
having here, it doesn't seem to be out-of-memory.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-04-12 14:27:31 Re: upper() with LATIN1 problem
Previous Message Stephan Szabo 2005-04-12 13:58:53 Re: Problem in order by