Re: Replication Syatem

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com> writes:
> That's weird. With that fillfactor, you should have a very high
> percentage of HOT update ratio. It could be a very special case that
> we might be looking at.

He's testing

>> update table1 set delta1 = 100 where code/1000000 =999;

so all the rows being updated fall into a contiguous range of "code"
values.  If the table was loaded in such a way that those rows were
also physically contiguous, then the updates would be localized and
would very soon run out of freespace on those pages.

			regards, tom lane