Simon Riggs <[EMAIL PROTECTED]> writes: > We discussed putting PreallocXlogFiles() in bgwriter once before, but I > think last time we discussed that idea it was rejected, IIRC.
We already do that: it's called a checkpoint. If the rate of WAL generation was more than checkpoint_segments per checkpoint_timeout, then indeed there would be a problem with foreground processes having to manufacture WAL segment files for themselves, but it would be a bursty thing (ie, problem goes away after a checkpoint, then comes back). It's a good thought but I don't think the theory holds water for explaining Cedric's problem, unless there was *also* some effect preventing checkpoints from completing ... which would be a much more serious problem than the archiver failing. 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