"Simon Riggs" <[EMAIL PROTECTED]> writes:
> Reading through the design, I see the following
> - bgwriter performs XLogWrite, not each backend
> - WAL fsync is only performed when WAL file fills
> - no checkpoints are performed until shutdown
> Not checkpointing at all is not a good plan, since this will lead to an
> enormous build up of WAL files and a very long recovery time if the
> system does fail.
Indeed, that seems utterly unacceptable; moreover it's hard to see how
you get a noticeable performance win, compared to a sane checkpoint
interval of some-fraction-of-an-hour.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
