Re: Hot Standby and VACUUM FULL
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-01-30T20:17:45Z
Lists: pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes: > The last item on my list before close is making VACUUM FULL and Hot > Standby play nicely together. > The options to do this were and still are: > (1) Add WAL messages for non-transactional relcache invalidations > (2) Allow system relations to be cluster-ed/vacuum full-ed. > (1) was how we did it originally and I believe it worked without > problem. We saw the opportunity to do (2) and it has been worth > exploring. Refresh my memory on why (1) lets us avoid fixing (2)? It sounds like a kluge at best ... regards, tom lane