From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
Cc: pgsql-admin@postgresql.org
Subject: Re: db restore eats too much memory
Date: Tue, 12 Apr 2005 10:09:01 -0400
Message-ID: <15394.1113314941@sss.pgh.pa.us> (raw)
In-Reply-To: <425B98BF.5090400@mail.jct.ac.il>
References: <425B98BF.5090400@mail.jct.ac.il>
Tsirkin Evgeny <tsurkin@mail.jct.ac.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, tsurkin@mail.jct.ac.il
Subject: Re: db restore eats too much memory
In-Reply-To: <15394.1113314941@sss.pgh.pa.us>
References: <425B98BF.5090400@mail.jct.ac.il> <15394.1113314941@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox