Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id A90A91337B8C
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 31 Jan 2011 17:28:56 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 76111-04-5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 31 Jan 2011 21:28:49 +0000 (UTC)
X-Greylist: delayed 00:05:38.26608 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 C78841337B5D
	for <pgsql-performance@postgresql.org>;
	Mon, 31 Jan 2011 17:28:45 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.catalyst.net.nz (Postfix) with ESMTP id EAC533217C
	for <pgsql-performance@postgresql.org>;
	Tue,  1 Feb 2011 10:23:03 +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 QI+wpd+EXxFq for <pgsql-performance@postgresql.org>;
	Tue,  1 Feb 2011 10:23:03 +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 0FEC932160
	for <pgsql-performance@postgresql.org>;
	Tue,  1 Feb 2011 10:23:02 +1300 (NZDT)
Message-ID: <4D472836.9000108@catalyst.net.nz>
Date: Tue, 01 Feb 2011 10:23:02 +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: 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>
In-Reply-To: <4D46FF15.7090606@agliodbs.com>
Content-Type: multipart/alternative;
	boundary="------------090201060909040008040804"
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: 201101/348
X-Sequence-Number: 42135

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

On 01/02/11 07:27, Josh Berkus 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.
>

Right - it might be interesting to see if you can reproduce on 8.4. I 
would hazard a guess that you will not (on disk FSM + visibility map 
vacuum improvements seem to make this whole area way better).

Cheers

Mark

--------------090201060909040008040804
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
    <title></title>
  </head>
  <body text="#000000" bgcolor="#ffffff">
    On 01/02/11 07:27, Josh Berkus wrote:
    <blockquote cite="mid:4D46FF15.7090606@agliodbs.com" type="cite">
      <pre wrap="">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.

</pre>
    </blockquote>
    <font size="-1"><font face="Helvetica"><br>
        Right - it might be interesting to see if you can reproduce on
        8.4. I would hazard a guess that you will not (on disk FSM +
        visibility map vacuum improvements seem to make this whole area
        way better).<br>
        <br>
        Cheers<br>
        <br>
        Mark<br>
      </font></font>
  </body>
</html>

--------------090201060909040008040804--