Sunday, September 28, 2008

Re: [PERFORM] Slow updates, poor IO

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

Tom Lane wrote:
John Huttley <> 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    

No comments: