Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> No real need to be random is there? In the bloated space scenario,
> VACUUM will be triggered but will be unable to remove the empty blocks.
> So in that case VACUUM can hint the FSM to perform "start from beginning
> of relation" behaviour.
No, that's an entirely unrelated issue. My point is that there won't
*be* any empty end blocks unless we discourage FSM from handing out
those pages as insertion targets.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Kevin Grittner||Date: 2009-10-01 16:32:08|
|Subject: Re: FSM search modes|
|Previous:||From: Tom Lane||Date: 2009-10-01 16:28:54|
|Subject: Re: hstore crasesh on 64bit Sparc |