Re: [COMMITTERS] pgsql: Avoid marking buffer dirty when VACUUM has no work to do.

2011-11-18 Thread Tom Lane
Simon Riggs writes: > Avoid marking buffer dirty when VACUUM has no work to do. > When wal_level = 'hot_standby' we touched the last page of the > relation during a VACUUM, even if nothing else had happened. > That would alter the LSN of the last block and set the mtime > of the relation file unne

[COMMITTERS] pgsql: Avoid marking buffer dirty when VACUUM has no work to do.

2011-11-18 Thread Simon Riggs
Avoid marking buffer dirty when VACUUM has no work to do. When wal_level = 'hot_standby' we touched the last page of the relation during a VACUUM, even if nothing else had happened. That would alter the LSN of the last block and set the mtime of the relation file unnecessarily. Noted by Thom Brown.