Re: proper tuning for restoring from pg_dump in 8.3.7

From: Kris Deugau <kdeugau(at)vianet(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: proper tuning for restoring from pg_dump in 8.3.7
Date: 2010-07-14 18:00:28
Message-ID: 4C3DFB3C.6070701@vianet.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Burgholzer, Robert (DEQ) wrote:
> OK, thanks to multiple folks for letting me know that I was looking at
> the wrong "top" metric. That said, my performance in most definitely
> suffering -- does this "swap" number seem excessive (looks like ~100 G
> to me):
> Swap: 102399992k total

Total swap isn't an issue (except maybe in wasted disk - that *does*
seem *very* high). It's the next column over (swap used) that you need
to keep an eye on.

-kgd

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-07-14 18:06:39 Re: proper tuning for restoring from pg_dump in 8.3.7
Previous Message Burgholzer, Robert (DEQ) 2010-07-14 17:45:25 Re: proper tuning for restoring from pg_dump in 8.3.7