"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.
>> 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
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2008-04-30 15:02:39|
|Subject: Re: Replication Syatem |
|Previous:||From: Tom Lane||Date: 2008-04-30 14:43:11|
|Subject: Re: Understanding histograms |