X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id B389FD852F
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 31 Aug 2005 15:25:19 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 10680-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 31 Aug 2005 18:25:16 +0000 (GMT)
Received: from web53209.mail.yahoo.com (web53209.mail.yahoo.com
	[206.190.49.79])
	by svr1.postgresql.org (Postfix) with SMTP id 2B811D842B
	for <pgsql-performance@postgresql.org>;
	Wed, 31 Aug 2005 15:25:15 -0300 (ADT)
Received: (qmail 89933 invoked by uid 60001); 31 Aug 2005 18:25:15 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=F1lwtU6uvUNLkADAkLvTSFq+O50g8f5T6ynl8XBGWFyPh8fLJ1hx7R1Q5GK+0Jxw4XmLgBy1swoGRyBw9y8U6hhgsDiuoD4APiVjTqo9md6zsfTcqwTEAakyhMFmtXByKSY0Lx9nwZw04Gp8H6yh3acsa4gjdqki584Ue3ENec0=
	;
Message-ID: <20050831182515.89931.qmail@web53209.mail.yahoo.com>
Received: from [201.24.119.165] by web53209.mail.yahoo.com via HTTP;
	Wed, 31 Aug 2005 15:25:15 ART
Date: Wed, 31 Aug 2005 15:25:15 -0300 (ART)
From: Carlos Henrique Reimer <carlosreimer@yahoo.com.br>
Subject: Swapping
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-353803500-1125512715=:87763"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.596 required=5 tests=[AWL=0.165,
	DNS_FROM_RFC_ABUSE=0.374, HTML_30_40=0.056, HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200508/557
X-Sequence-Number: 14304

--0-353803500-1125512715=:87763
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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 it swapping?
 
I´ve collected the following data from the environment and saved at http://paginas.terra.com.br/educacao/rei/dados.htm
 
1. select version()
2. uname -a
3. cat /proc/cpuinfo
4. cat /proc/meminfo
5. vmstat 5
6. pg_stat_activity
7. postgresql.conf
 
Thanks in advance!
 
Reimer


__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger 
http://br.download.yahoo.com/messenger/ 
--0-353803500-1125512715=:87763
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>
<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I´m trying to tune a linux box with a 12 GB database and&nbsp;4 GB RAM. First of all I would like to stop&nbsp;the swapping, so the shared_buffers and sort_mem were decreased but even so it started swapping two hours after DBMS started up.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I would like to know some suggestions how to discover why is it swapping?</DIV>
<DIV>&nbsp;</DIV>
<DIV>I´ve collected the following data from the environment and saved at <A href="http://paginas.terra.com.br/educacao/rei/dados.htm">http://paginas.terra.com.br/educacao/rei/dados.htm</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>1. select version()</DIV>
<DIV>2. uname -a</DIV>
<DIV>3. cat /proc/cpuinfo</DIV>
<DIV>4. cat /proc/meminfo</DIV>
<DIV>5. vmstat 5</DIV>
<DIV>6. pg_stat_activity</DIV>
<DIV>7. postgresql.conf</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks in advance!</DIV>
<DIV>&nbsp;</DIV>
<DIV>Reimer</DIV></DIV><p>__________________________________________________<br>Converse com seus amigos em tempo real com o Yahoo! Messenger <br>http://br.download.yahoo.com/messenger/ 
--0-353803500-1125512715=:87763--