pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
db restore eats too much memory
2+ messages / 2 participants
[nested] [flat]

* db restore eats too much memory
@ 2005-04-12 09:45 Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
  2005-04-12 14:09 ` Re: db restore eats too much memory Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Tsirkin Evgeny @ 2005-04-12 09:45 UTC (permalink / raw)
  To: pgsql-admin


Hi!
I am trying to copy my db from one machine to another .
However since my dump file is pretty big while trying to restore on the 
target one
the machine just "hangs up" - we got an empty black console and no ssh 
response.
We think that this is caused by postmaster eating too much memory the 
last top
screenshot is:

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.

This is pgsql 7.4.7 suse 9.
We had the same problems with rh 7.3 with pgsql 7.3 bug just managed ...
The memory on the machine was checked with memchack and is fine.
I know that i can limit the memory usage for postmaster but wouldn't
it make to crash ?
Thanks.
Evgeny.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: db restore eats too much memory
  2005-04-12 09:45 db restore eats too much memory Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
@ 2005-04-12 14:09 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-04-12 14:09 UTC (permalink / raw)
  To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-12 14:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-12 09:45 db restore eats too much memory Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
2005-04-12 14:09 ` Tom Lane <tgl@sss.pgh.pa.us>

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