Ahh! I've not dealt with that before. I'll look it up. Thanks Tom.
Tom Lane wrote:
John Huttley <[EMAIL PROTECTED]> 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