On Thu, Oct 1, 2009 at 4:47 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> A possible downside of keeping things compact this way is that you'd
> probably get a longer average search distance because of all the early
> pages tending to remain full. Maybe what we want is some bias against
> inserting in the last half or quarter of the table, or some such rule,
> rather than necessarily heading for the start of the relation.
Yeah, that seems better. Avoiding the last quarter seems like it
would likely be sufficient.
If it's not too hard, it might make sense to only apply this bias when
we know that the table is already somewhat bloated.
In response to
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-10-01 21:18:54|
|Subject: Re: FSM search modes|
|Previous:||From: Tom Lane||Date: 2009-10-01 21:08:12|
|Subject: Re: FSM search modes |