Horton

Re: Temporary tables prevent autovacuum, leading to XID wraparound

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Andres Freund <andres@anarazel.de>, pgsql-hackers@lists.postgresql.org, "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, "tgl@sss.pgh.pa.us" <tgl@sss.pgh.pa.us>, "robertmhaas@gmail.com" <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-08-13T16:53:18Z
Lists: pgsql-hackers 


  

  
Commits

  
  
    
    
  1. 
      
    Clarify comment about assignment and reset of temp namespace ID in MyProc
    
      
    
  2. 
      
    Make autovacuum more aggressive to remove orphaned temp tables
    
      
    
  3. 
      
    Don't count background workers against a user's connection limit.
    
      
    
    4.