Bruce Momjian <pgman@candle.pha.pa.us> writes: > + /* Even if zero_damaged_pages is true, we don't want autovacuum > zeroing. */ > + zero_damaged_pages = false;
This is completely incorrect; you need to set the variable via GUC, else it will still be overridden from postgresql.conf if a SIGHUP arrives. I believe this would work: SetConfigOption("zero_damaged_pages", "false", PGC_SUSET, PGC_S_SESSION); regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly