Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 667151A3D38D
	for <pgsql-performance@postgresql.org>;
	Sat, 28 Jul 2012 14:12:19 -0300 (ADT)
Received: from smtp1.wa.amnet.net.au ([203.161.124.50])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <dave@oneit.com.au>) id 1SvAYq-0001gx-Kx
	for pgsql-performance@postgresql.org; Sat, 28 Jul 2012 17:12:18 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by smtp1.wa.amnet.net.au (Postfix) with ESMTP id 626FB7DF31;
	Sun, 29 Jul 2012 01:12:01 +0800 (WST)
X-Virus-Scanned: amavisd-new at smtp1.wa.amnet.net.au
Received: from smtp1.wa.amnet.net.au ([127.0.0.1])
	by localhost (smtp1.wa.amnet.net.au [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id SlmvGpdSq0Hy; Sun, 29 Jul 2012 01:11:57 +0800 (WST)
Received: from [192.168.167.135] (203.161.71.159.static.amnet.net.au
	[203.161.71.159])
	by smtp1.wa.amnet.net.au (Postfix) with ESMTP id 21BA77DF05;
	Sun, 29 Jul 2012 01:11:57 +0800 (WST)
Message-ID: <50141D5A.2090302@oneit.com.au>
Date: Sun, 29 Jul 2012 01:11:54 +0800
From: David Barton <dave@oneit.com.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:14.0) Gecko/20120714 Thunderbird/14.0
MIME-Version: 1.0
To: Pavel Stehule <pavel.stehule@gmail.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
References: <50136B8D.7070502@oneit.com.au>
	<CAFj8pRB=Tq-xYeMHSE=52Oqkpx=miazcqEgwHa+m3cFxTo7i2g@mail.gmail.com>
In-Reply-To: 
 <CAFj8pRB=Tq-xYeMHSE=52Oqkpx=miazcqEgwHa+m3cFxTo7i2g@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------030404060600010208080007"
X-Pg-Spam-Score: -0.4 (/)
X-Archive-Number: 201207/351
X-Sequence-Number: 47532

This is a multi-part message in MIME format.
--------------030404060600010208080007
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Thanks, Pavel.

I was a bit worried about trying this because of a comment elsewhere 
that the file was supposed to be permanent.  Tom's solution of 
increasing the vacuum delay has solved it for now.

Regards, David


On 28/07/12 15:07, Pavel Stehule wrote:
> Hello
>
> I had same problem with large numbers of tables - you can move
> pg_stat_tmp to tmpfs filesystem - it was solution for us
>
> Regards
>
> Pavel
>
> 2012/7/28 David Barton <dave@oneit.com.au>:
>> Hi,
>>
>> <snip>

-- 

*David Barton - Managing Director*
1iT Pty Ltd "The Power of One"

Tel: (08) 9382 2296
Direct: (08) 9200 4269
Mob: 0404 863 671
Fax: (08) 6210 1354
Web: www.1it.com.au

First Floor
41 Oxford Close
West Leederville, 6007


--------------030404060600010208080007
Content-Type: multipart/related;
	boundary="------------000605090601020903000403"


--------------000605090601020903000403
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3DUTF-8" http-equiv=3D"Content-Ty=
pe">
  </head>
  <body bgcolor=3D"#FFFFFF" text=3D"#000000">
    Thanks, Pavel.<br>
    <br>
    I was a bit worried about trying this because of a comment elsewhere
    that the file was supposed to be permanent.=C2=A0 Tom's solution of
    increasing the vacuum delay has solved it for now.<br>
    <br>
    Regards, David<br>
    <br>
    <br>
    <div class=3D"moz-cite-prefix">On 28/07/12 15:07, Pavel Stehule wrote=
:<br>
    </div>
    <blockquote
cite=3D"mid:CAFj8pRB=3DTq-xYeMHSE=3D52Oqkpx=3DmiazcqEgwHa+m3cFxTo7i2g@mai=
l.gmail.com"
      type=3D"cite">
      <pre wrap=3D"">Hello

I had same problem with large numbers of tables - you can move
pg_stat_tmp to tmpfs filesystem - it was solution for us

Regards

Pavel

2012/7/28 David Barton <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:=
dave@oneit.com.au">&lt;dave@oneit.com.au&gt;</a>:
</pre>
      <blockquote type=3D"cite">
        <pre wrap=3D"">Hi,

&lt;snip&gt;
</pre>
      </blockquote>
      <pre wrap=3D"">
</pre>
    </blockquote>
    <br>
    <div class=3D"moz-signature">-- <br>
      <p>
        <img src=3D"cid:part1.06010101.05080600@oneit.com.au"
          align=3D"right">
      </p>
      <p> <b>David Barton - Managing Director</b><br>
        1iT Pty Ltd "The Power of One"
      </p>
      <p>
        Tel: (08) 9382 2296<br>
        Direct: (08) 9200 4269<br>
        Mob: 0404 863 671<br>
        Fax: (08) 6210 1354<br>
        Web: <a href=3D"www.1it.com.au">www.1it.com.au</a>
      </p>
      <p>
        First Floor<br>
        41 Oxford Close<br>
        West Leederville, 6007
      </p>
    </div>
  </body>
</html>

--------------000605090601020903000403
Content-Type: image/gif;
 name="Logo.gif"
Content-Transfer-Encoding: base64
Content-ID: <part1.06010101.05080600@oneit.com.au>
Content-Disposition: inline;
 filename="Logo.gif"

R0lGODlhyABgAOf/AAIAWgMBUwACWAUCTQAGSAAFTgMAYQACXwcDSAMIOQIIPgAFVAAIRAQK
MAkEQwACaQoFPgABcQUKNQgAZAQNLAsHOgABeggAagAAgwwLLA0LMQwAcw0CZgwOKQIIZwUA
jQAFjBIAfAgHeAAGlw8AmQsMbBMURBAXQRQYMhEVSxMPbwoVcxQWUxUUWwwLpQ8QhRcRchoe
NBMYaBAWfBQOnxsWbxcSkhgUmx0hTR4adhcVqg8bpiImPR8geCMmUiQnSyAfiiQdlCcrQiMl
cBwdsSMoZiYkfSQofC4vQSoscSUnqycopCglsiguiC0smTMvgzg5Vy81hzk7TTQruTc0gTY6
cjo6aTQvtzc1nj9CTzg1rTQ3u0A8i0RGYT89nztBmz5CkEVEdEM5uUZKXUVEjUJJgkBDskFB
vktPXExKwk1Rm1JVfEtRrFdaaVRWh1FQwFJZj1lWm1VamlhVyFVgllZcs2Jid1ZfrGRmclxh
pFpeylxfwWNioWVomGhnp/9BAGpvr2Vszv9DEWlwwHR4g3V1lnFzrW5yy215qv9LFf5SFHR5
z/9UIICCjHeAs/9VKHd+wHV+yYB+tXqEr32Fqf9cLoWFs/9iLP9jNImNlomMp4GI1oSMwf9p
NY2Mu4WQvP9qPYaO0v9sR5KWq4uXuZGUvJSUw5KatI6Xz/92TJiapJecnpqWwJCX2P96V5Wg
zaCcxpejxpmh1v+CZ6Gkup+jy52mwaWmrf+IY/+IbamozP6Pef+UcK6yta+v0v+YeLGzwLC0
yv+dh/+egrW02Li00rK307a6vf+llf6pirzAxMDCv7zC0b7B3sLGyf+zm/+0qMfI38bMzsTL
2svK0cvNyv68rs/P5s7T1tDS3NPV0tXV7P/Ku9nW6Nbb3trc2dfb69zb4v3Qyd3h8eHj3//Y
0ODl5+Lk7ubk6P/c0eXn5Ojq5+jt7+vr9v/m3O/s8ezv6/Dy7/D1+P/w6/Xz9/P18v7x8fb4
9Pz39fr8+f/6+f36//j9///9+/7//P///yH+FUNyZWF0ZWQgd2l0aCBUaGUgR0lNUAAh+QQB
CgD/ACwAAAAAyABgAAAI/gD9CRxIsKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzamzIjhktYOHu
5dtIsqTJkygd7ss2ycsLFUmAvbuXsqbNmzgfstMVSg8TEhZkKLNHM6fRowzd8cJ0qdOweQrT
SU3nzuY+f8Fk9bxCIsQDN+HgIR1LdiA+V3/+CPqT6JfCToriDrspD9GmRW+YfLDwoIi0d1fL
Csapbx6jtGv/gErI73BaXnTVpEmzhcbeC0mckSs6uHPKs4nTuk1YSa2g0Sn58eNzg4gLEHy/
ajMXmKE+z7gjzhuWKpWrZ1BJp/0DOWU/gcFmfMCw4cIEGbe+wRupUF85ZK5S/eJ2O7d3xveC
/vNLqM/xH9QO5U2rZQudPOoK+eU71eOB/SOqsKGjV/vgPm65pALKI4IwwktwuPX3nUD7jLfQ
eIet9Ut3De3jCyBOPFAFNew0hE881FBSiCYgkSOWQv2IAw0yu7iCCSMS4hNRO9EQY2M07WzU
jY3EdKOgROM0w2M3GVHIGIyPOdgQM69EogUNHKyx30IN+kNPPOuoo8469vxYkD3QhCnMLKI8
kogginBTYTSecAGDB3ByUEINTxgSDT0NxXHEE7UIRI8vcfRQA5xz9uBHNEo21E4xauRQQgke
QFpCD2rUMk6iDuECyqZzFZSOgJ2AkohafzCyKSidJJPQPvI4coge/kp8cEERynTIED/H4YPP
PeNhWhA/5YQJzZipVKKIhA+ew0cOBzxggAcr1MDsBAcYsIIa1/haEBUGTGDKPs2A4cEEE3hQ
w6ATGGCACpLkyBA9ulDhgQEHRHpuCQeky8ERrLj7UGlp4WIQN6OGNtxwghSHkDxwaMEEDRjM
Sg06XiKkWpXHrWpNmMgIk0uZiZyZSnXEHGHAAwccYYguxUQTjS+WPMGBujXAUrE//ERBriee
rPBsFKa0/LIlR8zrAR94KiSPHyVMwMEKcdRijMvE6KJGDd16oAY4EF0ynMAEAYsqqmutpUio
oXbq3z6URPBBCBEAsEY15MC3UD/H9aNt/kH7QLNLxy2WKciZrihkStMGHFHLPhmrxk+DxoCh
rgeG3MztBE+UYAAXzQj0+FX80GPIzAZwotA7cWRtyDkj3darPu2w4rMBOXDtECZfJ5RPY8P9
Mt4++uwtUD/vhLHAAQFYsUw48tycUMbxcePKLLO4IgomIbOlKkK6rEDu1oni7U8/++TTDiD0
euDJ3jpXy4Ec9GCqN6txzGyEvwUtPe8KtfCHs4MZu0o3olCtKODvebhbC9gsBrDzPEQ17LhF
JlRBjW/M5CTks4f1RHE9M63lEulACD2MQC8wnAN6BzkOPfjggQOogEgHocIEnEWGduAKIfoA
h9GMgRBfeM8D/jY7zlVQaJZokJADknDeQLwWML4VJELEUSLfQvcOdhBFihXhBzcw8QgPpiUR
z7CYKU5WAxg25BxNOAAH/ICp8RBwAitoBhHDdhsSGoAVB+GHDA0gB3kwxh8Nuo0n1HWEcdwK
d01EyFXMozCVqIZXwstIg/6DicENjhHPMBJB2tE+QMxxVbVwVg3OURC9XY4MSVuI5B5QOYMU
gwPlMkU3tkHLWtpyG+CoJTF6oC5dSNFrCowPFNHjECFGUiPH4Yc9xJGMYTyjKgjpxzm8V4Ji
RGQaOXBWNA5CQAPwoSH9yIO65KAgfsBiXAY4lzrXqc5onWsFKsiXAQDREET+YYEG/tEbIyny
yZMEskGqQVE4aLbNh+xjHEeoVp8MIsMJGMIhfFCXGg5iiW4Z4FEYzWgJVIBRjs5pBSWAgRwa
Asx7LsQ8xFxQQTTpn4EeIAfXgMhBm6CuhQ5kPFQ4wAFMAU5xGkAN/blKRR/whGYY9ahIbUY0
jhqNYhh1qTG9GxNNeiRSNVKlYWsIP9qxggd4gIcQuUYNHsCBqA7kODJ8AE8bwgeyxsEg/GDF
vHLwoJvyQx+7YylCShNMhTQwpVgt5j7oAQZn+QEi/ShFtXpAyrDpMV9rZUhED6AGI+ktGpDy
gFkJMsSADmQfWPTcVPH5K3/sM7AU4ccnqrWCzS6kHU8g/qsfFIRWckV2IXyYYRx8tQ8wpIsP
N8Obg/IRDTno4oDC6WsKTUsqwKKWIXiThxFmBoZUrsofeagWDAwJV24Z4LaMye4B4lBOf/hC
cx7QBYoYBA4jOEsSWh3tqnj3mOdSZB/RGKsBwOBag7RDnHDURT915i2I6jafqrHE/kwRyX0Y
owfzekJjGcJXqiZkmPZN7YPTZQRPdKON3ajFE/b3iZvp7LsOAXBlSxm8dkT0otiyrkBoZAgV
EDJbWk2ghfOI0gxThB7RiEILH2CEOFgCFr7QBSf4IDN19UAXMkqId8GbkIhOYLdwPQ47DKE5
AKgADIaohS98YQpDkMHGJczG/g1JmjuFQJEXofUxIAWC13Y4ogbpIusD0qWuaqkAEOe4mRvT
ReU85oFa5FXkbYrBhRbObM/qohaHYWFDg+qYtL86rZwhEtDB1sIPVDjCCuBphCjIwRTneBzO
oskPS/CBD9ZsSC1ejUf/2PUaklDDEWqgAhio4AhgJsbu+pkQUDBCEQZaiLEZwQi1PVce7GCH
H/1ht7rirB3h6Ia2z+Gu7hC7H3g1KLX/dzd9dOeg4Eh3N7i9aonwYx7uiDeCEBJveT+XH+ew
RR/KUIUwaCIb9ODVA8ENPAaBNjUBJfZNGTQecAdvfGueiOP0alfHHXMw/MgGKRyRBy8AYQYB
wMEt/qwo42iu+uLI5OfChzgR0OoDbwof3/jEh1p8MMMWrwjFIN6wBBtYQAAmGPkFZbrpjKC8
6OCIxSu0gpcrQOwCBfiBZvxX9KovaOOoaMUiApEGJdAABBEQQAUa4Y111MPqaMfNOcoAiEhs
/Q1bcA0GImAAAkDhG+R4R8nTzvecZCMJXnjDG86whSnQYARzN0DUpSEdzvT98TiZRguAoAQm
TGEHJCDB3FGGAKl/wxxUh7zoU+INBlzgAyRwAQneZoEIpAsBUKjGN9Rx9tHb3iSq8UEARICB
3lvAAhfYswAYYAdphAMd9Yjz7ZePIn3sIxMKCMAFIhCBCzjHAAAYAA56/iF7dtSe+eDP4j3e
MQYFDAAA6qJX9hXQiGpMbB33UH7458+ge+BDG2NIAAMKMIABFIAAJkAIzqAN2rAOe0d/CKgQ
DSIP6JAJPCABCaAAJ9AFFFQN4aAOM3F0CYiAL4cP8PAO60ANvdALA+h+34AO8EAPMbeBLNgr
V6IO5PAN2vAN4eAN5LAO8BBlLLiD62Ul9GAP8IAOW2IPXNI8PHiECugPvEIP9SAP9iAP8qCB
SLiBgWFuDUduU5iFBgFQnEVzWvh48hAO2TAN2WAOqvYQK/iFaMcOwUAJZVAELAABOGAHwDBY
oaeGLZgNsUAJk5AHZHAEMlAACpABbeAN8RBw/tWGh+HHDzcXC7HwCYbABk0AAyUQAArQAGOA
DeygdweoiKOnD9NACragdJwQCWzgBEEQfAOQAB2ABltyiN/nict3DpRACkr3CTr3BlpgA14R
ABCgAR2QCeZgDuxAD50oi3wXC3TwCZyACqUYCGagBTsAAhugeBWQAUKAd+sQD/WQiMjId/Kw
BnAACJAQCYMQCIP3MHthAAOgAMB4C8cHevTgjd9oddNQBWSgBndQB3vwBmZwBTowAusoAAQg
ARpACNoQDiYyj/UIecFQBFHQBF5gBtF4eTqwHNVHkNeIBwRoDuhwiA2JE/jGDLEwCXAAB31A
Iu+QRf5ACykgA07g/gRLUHmYp3mJFwAEcI1tIA3UQA7qcIj0GJJGdw7GQAqIYAhwQAZUIAMt
wAJWMAroMBHHAQwvuQIvYAM3QAMugHiJl30MkAANgAfVQIAomHxCeRI2RwqfsJacYAh3AAZO
kAMC0I5QwAzypxre8AMIIAAq0HsYsBwbQH3YNwAMIAEZkAnul5DeF5RnmVq2sJavEJmooHNs
gAUfpwILwAAacAtSKFxdIAELcDIR0HqtNwEAAAABgADuiALH4Ayyhw7bKH+NqRD4EAuI8Amv
UAuyIAuTuQh1YAZB8AIiwAGWmAG3IA+OtxDOdwsZkAAIEADoVy3YN5cEAAEJQIjLQA3U/qAN
sBkPjDmbEGEMdOAInLB0SzeZkbAHZqAEN/ACGwAACCABPEAN5eMQ40F+GSABCoAAAxAAAdCf
CEAAhZkBSNALyrAMskcO9mCW4GkR+8AOYZAHhtAKqLCbrdAKm/AqZ+B16+iLhPgO7+EQ+YAP
2CAEFNAACqAADCCg1ZkA14kCmZCd2vl58CASDXoRpEAFakCOF3qhofB2Z2B4lwEAmokCvWAP
d2gx5RMP2CAFHXCiEJgAEjClFCAEq7AMBzqWsBlwsnmjA4EOZRAFX1AHg7AJmxAKZvoqlMEE
OqB5F6B4rNgG8JCCjJlMu7IO3kAISNABGdAAftoBMdAGBiqj/jNoDgbopRUBii1wBFjABntw
CIuwCIcQCHowB2dwBURweK3HjhVQpeFgDikIXcqED+uADtKQCXiABlnQBo3QC1iKpWOpjcj5
nYiaR/pACy3QA05AkXOgB76qB4O3BWw6AohHd5nZADGwDFuanHlkf0EYg+FAgNSQnTK6nQqJ
Dk8ohbV6U5pQACsABEugBWeQBnOQBmcgBoW3AzSwehaQLr74jngHD1jEKkCIDjHoDdWQr+43
ljNIDt2JDxS3rfFRCAhQAjMQBEuwBQqrsFfApqoHAhgAfOsnAR2QH2XHkLciD/XwDjCIDjSI
DTSoDeTgr9sYhQJLEZTAAB4gAjZA/gM7wASWRwQOu3oR63peCYyrMIPqIK8O4XzjZw/qYK8e
66/osKW7ErAnqxCqoAAHMJofMAJaqQOqt64QGwKbCp8KIAFGup2gyqyrkg9QGA9EuA5kyyXw
EA/yoINJy2nAIAED0LQWgHqZl3nLgQFw86YGQJDXyQMIqh8GqHwjeg/ycIjvgA/00Dw0oa1r
izfhgAIMsAAPMJp++ZcR+3uul7cFAAEUOwbUkK+G6rVwxVnjcxv7cA8icXBr+2N20AAEEAAH
MH0WYLWBCXx4m30OMIjBmJ0gC6JSBD2JQrppmLq2BkjA0AESQAADYAAcYH3UN33p958EkLUd
kAWuGqtm/odYWSW8GXEP8EAI+ckAe4l+6XeaADCXCKC5GRADV5qd3Gl2Xeo52nsRj/MO35AF
xqsABFAA/gmd/tl/0XudHUAIvXAM7IsO7AC64BS/GGG67yANe9oA+gkBBBCgAVqdWUsBHYAH
BHwMyiB76mAPZ6jASAFuG2sO1IAGfArBEZiiLvqnMUAIx+CqykAN4fB5aivCSMEP9xAP70AO
2pAJe0oBJ+qnDYDBKIAGqxDDy3AM21mAaKu4OCxJ/IAl6KAN2KAMmdAGSMADMRADSJAFeHCl
ruqq7BsO23jDUWwU+nAP9FCq39C5S7wMqzCCrqrEBDzD1QCb9oAPUJzGGHEVmPQADzCIDZ17
oEtMwHWMpdo5gwY8bX5MFoBsD0X7DYTsDM6wDHGMyQhaQSO7oPnwvo9sdB7oxtrgfp2rnagc
rUULD8gZyp1hf6N8fDKIDQTYrzdYsvgAyq58EaClGrpSD2VbtMJMsk+Ixrs8FuDmy/SAD0BI
tnPKzPggD8HTx8e8EcL1P/YHy00IQMFbzTghRBAXUEiLWgEBADs=
--------------000605090601020903000403--

--------------030404060600010208080007--