On Mon, Nov 14, 2016 at 3:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Magnus Hagander <magnus@hagander.net> writes: > What I'm talking about is something that would be a lot simpler than > auto-clustering. I'm not even talking about trying to detect if the row was > about to go into the right place -- this might be expensive and certainly > more complicated. I'm only talking about a simple case where we *never* put > anything anywhere other than at the end of the table, period. That should > make the check both cheap and simple.
It also makes it so much of a corner case that even a cheap check could be a net performance degradation, especially for people whose usage pattern doesn't match this.
I agree that it definitely solves just one problem. But it seems to be a fairly common problem, particularly for users of BRIN users.
Full auto-clustering would cover many more usecases, but would also be a lot more expensive to maintain.