[Tobias Brox - Wed at 09:22:17PM +0200]
> I'd trust linux to handle swap/cache sensibly. Eventually, become involved
> with kernel hacking ;-)
Of course, there are also some files in /proc/sys/vm that you may want to
peek into, for tuning the swapping. Particularly, at later 2.6-kernels (I'm
run
[Carlos Henrique Reimer - Wed at 03:25:15PM -0300]
> I´m trying to tune a linux box with a 12 GB database and 4 GB RAM. First
> of all I would like to stop the swapping, so the shared_buffers and sort_mem
> were decreased but even so it started swapping two hours after DBMS started
> up.
>
> I wo
Carlos Henrique Reimer <[EMAIL PROTECTED]> writes:
> I would like to know some suggestions how to discover why is it swapping?
Zero swap-in rate and swap-out rates in the single digits do not
constitute a swapping problem. It's reasonably likely that that
traffic isn't even coming from Postgres,
Hi,
I´m trying to tune a linux box with a 12 GB database and 4 GB RAM. First of all I would like to stop the swapping, so the shared_buffers and sort_mem were decreased but even so it started swapping two hours after DBMS started up.
I would like to know some suggestions how to discover why is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Guillaume Nobiron wrote:
| Hi,
|
| Environment :
| - Fedora Core 2 (kernel 2.6.10)
| - postgresql 7.4.7
|
| I am running a huge query with several joins that needs around 900
| Mbytes of Memory (System RAM is 512 Mbytes).
|
| When the system starts to
Hi,
Environment :
- Fedora Core 2 (kernel 2.6.10)
- postgresql 7.4.7
I am running a huge query with several joins that needs around 900
Mbytes of Memory (System RAM is 512 Mbytes).
When the system starts to swap the postgres process, CPU consumed drops
to around 2% (instead of around 50% on an
Andrew Sullivan wrote:
> On Wed, Jan 19, 2005 at 10:42:26AM -0500, Alan Stange wrote:
> >
> > I'm fairly sure that the pi and po numbers include file IO in Solaris,
> > because of the unified VM and file systems.
>
> That's correct.
I have seen cases on BSDs where 'pi' includes page-faulting in
On Wed, Jan 19, 2005 at 10:42:26AM -0500, Alan Stange wrote:
>
> I'm fairly sure that the pi and po numbers include file IO in Solaris,
> because of the unified VM and file systems.
That's correct.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions.
On Wed, 2005-01-19 at 09:40 -0600, Kevin Schroeder wrote:
> I may be asking the question the wrong way, but when I start up PostgreSQL
> swap is what gets used the most of. I've got 1282MB free RAM right now and
> and 515MB swap in use. Granted, swap file usage probably wouldn't be zero,
> but
al Message -
From: "Matt Clark" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 1:01 PM
Subject: Re: [PERFORM] Swapping on Solaris
This page may be of use:
http://www.serverworldmagazine.com/monthly/2003/02/solaris
available
Kevin
- Original Message - From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may be asking the question t
On Jan 19, 2005, at 10:40 AM, Kevin Schroeder wrote:
I may be asking the question the wrong way, but when I start up
PostgreSQL swap is what gets used the most of. I've got 1282MB free
RAM right now and and 515MB swap in use. Granted, swap file usage
probably wouldn't be zero, but I would gues
Kevin Schroeder wrote:
I may be asking the question the wrong way, but when I start up
PostgreSQL swap is what gets used the most of. I've got 1282MB free
RAM right now and and 515MB swap in use. Granted, swap file usage
probably wouldn't be zero, but I would guess that it should be a lot
low
used, 2988840k
available
Kevin
- Original Message -
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may
On Jan 19, 2005, at 10:42 AM, Alan Stange wrote:
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar
-g 5 10 and when a request was made (totally about 10 DB queries) my
pgout/s jumped to 5.8 and my ppgout/s jumped to 121.8. pgfree/s also
jumped to 121.8
--
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 9:30 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I suspect that the memory is being used to cache files as well
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar
-g 5 10 and when a request was made (totally about 10 DB queries) my
pgout/s jumped to 5.8 and my ppgout/s jumped to 121.8. pgfree/s also
jumped to 121.80.
I'm fairly sure that the pi and po numbers inc
in Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 9:42 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar -g
5 10 and when a request was made (totally about 10 DB queries)
Alan Stange wrote:
Note that files in /tmp are usually in a tmpfs file system. These
files may be the usage of swap that you're seeing (as they will be paged
out on an active system with some memory pressure)
You can do a couple things with /tmp. Create a separate file system
for it so it will
Kevin Schroeder wrote:
I suspect that the memory is being used to cache files as well since
the email boxes are using unix mailboxes, for the time being. With
people checking their email sometimes once per minute I can see why
Solaris would want to cache those files. Perhaps my question would
r PostgreSQL to be swapped unless that free
memory is Solaris caching files in RAM.
Kevin
- Original Message -
From: "Greg Spiegelberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, Januar
Stange" <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 19, 2005 7:51 AM
Subject: Re: [PERFORM] Swapping on Solaris
Mark Kirkwood wrote:
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really h
t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
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
:-)
Indee
- Original Message -
From: "Matt Casters" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
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,
Mark Kirkwood wrote:
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really high,
this is what Solaris shows me when running top:
Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free
Maybe check the swap usage with 'swap -l' which reports reliably if an
> 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 l
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really high, this
is what Solaris shows me when running top:
Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free
Maybe check the swap usage with 'swap -l' which reports reliably if any
(device or file) sw
Hello,
I'm running PostgreSQL on a Solaris 8 system with 2GB of RAM and I'm
having some difficulty getting PostgreSQL to use the available RAM. My RAM
settings in postgresql.conf are
shared_buffers = 8192 # min 16, at least max_connections*2, 8KB each
sort_mem = 131072 # min
> This is normal. My personal workstation has been up for 16
> days, and it shows 65 megs used for swap. The linux kernel
> looks for things that haven't been accessed in quite a while
> and tosses them into swap to free up the memory for other uses.
>
> This isn't PostgreSQL's fault, or anyt
decreases according to top.
>
> --- On Tue 07/13, Matthew T. O'Connor < [EMAIL PROTECTED] > wrote:
> From: Matthew T. O'Connor [mailto: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Date: Tue, 13 Jul 2004 16:26:09 -0400
> Subjec
IL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Tue, 13 Jul 2004 16:26:09 -0400
Subject: Re: [PERFORM] Swapping in 7.4.3
Jim Ewert wrote:> When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements
are that it doesn't initially take much memory (have 512M) and didn't swap. I ran a
Jim Ewert wrote:
When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements are that it doesn't
initially take much memory (have 512M) and didn't swap. I ran a full vaccum and a
cluster before installation, however speed degaded to 1 *second* / update of one row
in 150 rows of data, within a
When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements are that it doesn't
initially take much memory (have 512M) and didn't swap. I ran a full vaccum and a
cluster before installation, however speed degaded to 1 *second* / update of one row
in 150 rows of data, within a day! pg_autovac
33 matches
Mail list logo
