Re: Swapping on Solaris - Mailing list pgsql-performance

From Matt Casters
Subject Re: Swapping on Solaris
Date
Msg-id 25392.193.190.212.113.1106128630.squirrel@193.190.212.113
Whole thread Raw
In response to Re: Swapping on Solaris  (Mark Kirkwood <markir@coretech.co.nz>)
List pgsql-performance
> Kevin Schroeder wrote:
> It looks to me like you are using no (device or file) swap at all, and
> have 1.3G of real memory free, so could in fact give Postgres more of it :-)
>

Indeed.
If you DO run into trouble after giving Postgres more RAM, use the vmstat command.
You can use this command like "vmstat 10". (ignore the first line)
Keep an eye on the "pi" and "po" parameters. (kilobytes paged in and out)

HTH,

Matt
------
Matt Casters <matt.casters@ibridge.be>
i-Bridge bvba, http://www.kettle.be
Fonteinstraat 70, 9400 Okegem, Belgium
Phone +32 (0) 486/97.29.37


pgsql-performance by date:

Previous
From: amrit@health2.moph.go.th
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql
Next
From: Richard Huxton
Date:
Subject: Re: Increasing RAM for more than 4 Gb. using postgresql