Re: Slow updates, poor IO

[John Huttley <John@xxxxxxxxxxxxxxxxxx>]

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


Tom Lane wrote:

John Huttley <John@xxxxxxxxxxxxxxxxxx> 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