Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 5B32C1337C50
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  1 Feb 2011 19:39:30 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 98690-01-8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue,  1 Feb 2011 23:39:22 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.catalyst.net.nz (bertrand.catalyst.net.nz [202.78.240.40])
	by mail.postgresql.org (Postfix) with ESMTP id 561E31337BA1
	for <pgsql-performance@postgresql.org>;
	Tue,  1 Feb 2011 19:37:35 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.catalyst.net.nz (Postfix) with ESMTP id 6D2CE321EB;
	Wed,  2 Feb 2011 12:37:32 +1300 (NZDT)
X-Virus-Scanned: Debian amavisd-new at catalyst.net.nz
Received: from mail.catalyst.net.nz ([127.0.0.1])
	by localhost (bertrand.catalyst.net.nz [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id WwT0r7OxxP9y; Wed,  2 Feb 2011 12:37:31 +1300 (NZDT)
Received: from [192.168.1.11] (122-60-64-230.jetstream.xtra.co.nz
	[122.60.64.230]) (Authenticated sender: mark.kirkwood)
	by mail.catalyst.net.nz (Postfix) with ESMTPSA id 2BAF831F9D;
	Wed,  2 Feb 2011 12:37:31 +1300 (NZDT)
Message-ID: <4D48993A.30207@catalyst.net.nz>
Date: Wed, 02 Feb 2011 12:37:30 +1300
From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.2.13) Gecko/20101208 Thunderbird/3.1.7
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: Josh Berkus <josh@agliodbs.com>, Robert Haas <robertmhaas@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages?
References: <4D3E34C8.9040209@agliodbs.com>
	<AANLkTi=n6RCz_RSGhY4+AG6CbYWjLbKX6ohEvHoKNE+N@mail.gmail.com>
	<4D3F163E.100@agliodbs.com>	<4D3F40BD.4040504@catalyst.net.nz>
	<4D46FF15.7090606@agliodbs.com>
	<AANLkTikw9e8-DwL8vVX=yOLOUiO5E4vjCkk4HhhXU-Lt@mail.gmail.com>
In-Reply-To: <AANLkTikw9e8-DwL8vVX=yOLOUiO5E4vjCkk4HhhXU-Lt@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------090606040105060406010105"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201102/12
X-Sequence-Number: 42150

This is a multi-part message in MIME format.
--------------090606040105060406010105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 01/02/11 10:57, Scott Marlowe wrote:
> On Mon, Jan 31, 2011 at 11:27 AM, Josh Berkus<josh@agliodbs.com>  wrote:
>> Robert, Mark,
>>
>> I have not been able to reproduce this issue in a clean test on 9.0.  As
>> a result, I now think that it was related to the FSM being too small on
>> the user's 8.3 instance, and will consider it resolved.
> I used to try and size free space map to be a little bigger than it
> needed to be.  I now size 4 or 5 times what it needs to be.  shared
> memory is cheap.  So is going to 8.4, but on legacy systems that you
> can't upgrade, 8.3 with a huge FSM works well enough (with suitably
> aggressive autovac).
>

Yeah, 8.3 with very aggressive autovac my experience too - I've had the 
naptime cranked down to 10s or even 1s in some cases, to try to tame 
bloat growth for web cache or session type tables that are heavily 
volatile.

regards

Mark

--------------090606040105060406010105
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#ffffff">
    On 01/02/11 10:57, Scott Marlowe wrote:
    <blockquote
      cite="mid:AANLkTikw9e8-DwL8vVX=yOLOUiO5E4vjCkk4HhhXU-Lt@mail.gmail.com"
      type="cite">
      <pre wrap="">On Mon, Jan 31, 2011 at 11:27 AM, Josh Berkus <a class="moz-txt-link-rfc2396E" href="mailto:josh@agliodbs.com">&lt;josh@agliodbs.com&gt;</a> wrote:
</pre>
      <blockquote type="cite">
        <pre wrap="">Robert, Mark,

I have not been able to reproduce this issue in a clean test on 9.0. &nbsp;As
a result, I now think that it was related to the FSM being too small on
the user's 8.3 instance, and will consider it resolved.
</pre>
      </blockquote>
      <pre wrap="">
I used to try and size free space map to be a little bigger than it
needed to be.  I now size 4 or 5 times what it needs to be.  shared
memory is cheap.  So is going to 8.4, but on legacy systems that you
can't upgrade, 8.3 with a huge FSM works well enough (with suitably
aggressive autovac).

</pre>
    </blockquote>
    <font size="-1"><font face="Helvetica"><br>
        Yeah, 8.3 with very aggressive autovac my experience too - I've
        had the naptime cranked down to 10s or even 1s in some cases, to
        try to tame bloat growth for web cache or session type tables
        that are heavily volatile. <br>
        <br>
        regards<br>
        <br>
        Mark<br>
      </font></font>
  </body>
</html>

--------------090606040105060406010105--