Re: Slow updates, poor IO

From: John Huttley <John(at)mib-infotech(dot)co(dot)nz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow updates, poor IO
Date: 2008-09-28 21:53:31
Message-ID: 48DFFCDB.3020000@mib-infotech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Tom Lane wrote:
> John Huttley <John(at)mib-infotech(dot)co(dot)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
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John Huttley 2008-09-28 22:22:36 Re: Slow updates, poor IO
Previous Message Scott Carey 2008-09-28 16:24:06 Re: Slow updates, poor IO