Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

dbcommands.c

Blame
    • Tom Lane's avatar
      78a572bf
      When cloning template0 (or other fully-frozen databases), set the new · 78a572bf
      Tom Lane authored
      database's datallowconn and datfrozenxid to the current transaction ID
      instead of copying the source database's values.  This is OK because we
      assume the source DB contains no normal transaction IDs whatsoever.
      This keeps VACUUM from immediately starting to complain about unvacuumed
      databases in the situation where we are more than 2 billion transactions
      out from the XID stamp of template0.  Per discussion with Milen Radev
      (although his complaint turned out to be due to something else, but the
      problem is real anyway).
      78a572bf
      History
      When cloning template0 (or other fully-frozen databases), set the new
      Tom Lane authored
      database's datallowconn and datfrozenxid to the current transaction ID
      instead of copying the source database's values.  This is OK because we
      assume the source DB contains no normal transaction IDs whatsoever.
      This keeps VACUUM from immediately starting to complain about unvacuumed
      databases in the situation where we are more than 2 billion transactions
      out from the XID stamp of template0.  Per discussion with Milen Radev
      (although his complaint turned out to be due to something else, but the
      problem is real anyway).