• Tom Lane's avatar
    Arrange to put TOAST tables belonging to temporary tables into special schemas · 82eed4db
    Tom Lane authored
    named pg_toast_temp_nnn, alongside the pg_temp_nnn schemas used for the temp
    tables themselves.  This allows low-level code such as the relcache to
    recognize that these tables are indeed temporary, which enables various
    optimizations such as not WAL-logging changes and using local rather than
    shared buffers for access.  Aside from obvious performance benefits, this
    provides a solution to bug #3483, in which other backends unexpectedly held
    open file references to temporary tables.  The scheme preserves the property
    that TOAST tables are not in any schema that's normally in the search path,
    so they don't conflict with user table names.
    
    initdb forced because of changes in system view definitions.
    82eed4db
catversion.h 2.58 KB