Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 6E11137BFAA
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 28 Sep 2008 18:53:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 25482-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Sun, 28 Sep 2008 18:53:38 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gatekeeper.Mib-infotech.co.nz
	(60-234-154-229.bitstream.orcon.net.nz [60.234.154.229])
	by postgresql.org (Postfix) with ESMTP id 821A437B9B1
	for <pgsql-performance@postgresql.org>;
	Sun, 28 Sep 2008 18:53:38 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by gatekeeper.Mib-infotech.co.nz (Postfix) with ESMTP id 2291810C6EF;
	Mon, 29 Sep 2008 10:53:34 +1300 (NZDT)
X-Virus-Scanned: amavisd-new at mib-infotech.co.nz
Received: from gatekeeper.Mib-infotech.co.nz ([127.0.0.1])
	by localhost (gatekeeper.mib-infotech.co.nz [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id ulD+ex7x9FTF; Mon, 29 Sep 2008 10:53:30 +1300 (NZDT)
Received: from [192.168.95.202] (mr-creosote.mib-infotech.co.nz
	[192.168.95.202])
	by gatekeeper.Mib-infotech.co.nz (Postfix) with ESMTPA id 4B68C10C6EE;
	Mon, 29 Sep 2008 10:53:30 +1300 (NZDT)
Message-ID: <48DFFCDB.3020000@mib-infotech.co.nz>
Date: Mon, 29 Sep 2008 10:53:31 +1300
From: John Huttley <John@mib-infotech.co.nz>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-performance@postgresql.org
Subject: Re: Slow updates, poor IO
References: <48DBE587.3050406@mib-infotech.co.nz>
	<20080926131556.GA1005@commandprompt.com>
	<48DD6A4A.10209@mib-infotech.co.nz>
	<dcc563d10809270809g17938b7fvf28a3624028e0f3b@mail.gmail.com>
	<48DEB4D4.1020100@mib-infotech.co.nz>
	<6110.1222612388@sss.pgh.pa.us>
In-Reply-To: <6110.1222612388@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------070302060404080506090106"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.716 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, RCVD_IN_SORBS_DUL=1.615, RDNS_DYNAMIC=0.1
X-Spam-Level: *
X-Archive-Number: 200809/244
X-Sequence-Number: 31557

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

Ahh! I've not dealt with that before. I'll look it up.
Thanks Tom.


Tom Lane wrote:
> John Huttley <John@mib-infotech.co.nz> writes:
>   
>
>> You are thinking of HOT?
>> I don't think it applies in the case of full table updates??
>>     
>
> Sure, as long as there's enough free space on each page.
>
> If you wanted to make a table that was optimized for this kind of thing,
> you could try creating it with fillfactor 50.
>
> 			regards, tom lane
>
>   

--------------070302060404080506090106
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">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Ahh! I've not dealt with that before. I'll look it up.<br>
Thanks Tom.<br>
<br>
<br>
Tom Lane wrote:
<blockquote cite="mid:6110.1222612388@sss.pgh.pa.us" type="cite">
  <pre wrap="">John Huttley <a class="moz-txt-link-rfc2396E" href="mailto:John@mib-infotech.co.nz">&lt;John@mib-infotech.co.nz&gt;</a> writes:
  </pre>
  <br>
  <blockquote type="cite">
    <pre wrap="">You are thinking of HOT?
I don't think it applies in the case of full table updates??
    </pre>
  </blockquote>
  <pre wrap=""><!---->
Sure, as long as there's enough free space on each page.

If you wanted to make a table that was optimized for this kind of thing,
you could try creating it with fillfactor 50.

			regards, tom lane

  </pre>
</blockquote>
</body>
</html>

--------------070302060404080506090106--