On Tue, Jan 12, 2016 at 12:57 AM, Andres Freund <and...@anarazel.de> wrote:> > > My theory is that this happens due to the sorting: pgbench is an update > heavy workload, the first few pages are always going to be used if > there's free space as freespacemap.c essentially prefers those. Due to > the sorting all a relation's early pages are going to be in "in a row". >
Not sure, what is best way to tackle this problem, but I think one way could be to perform sorting at flush requests level rather than before writing to OS buffers. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
