• Robert Haas's avatar
    Allow hint bits to be set sooner for temporary and unlogged tables. · 53f1ca59
    Robert Haas authored
    We need not wait until the commit record is durably on disk, because
    in the event of a crash the page we're updating with hint bits will
    be gone anyway.  Per off-list report from Heikki Linnakangas, this
    can significantly degrade the performance of unlogged tables; I was
    able to show a 2x speedup from this patch on a pgbench run with scale
    factor 15.  In practice, this will mostly help small, heavily updated
    tables, because on larger tables you're unlikely to run into the same
    row again before the commit record makes it out to disk.
    53f1ca59
bufmgr.h 6.7 KB