webb sprague <wsprague@o1.com> writes:
> Is there a way to flush them more often?
Reduce the time interval between WAL checkpoints. (But don't overdo it.)
Perhaps every three or so minutes, rather than five?
> Otherwise, they can fill up the
> disk space and crash the postmaster. I am doing bulk copies, but the logs
> hang around for up to 20 minutes after the copy is finished.
Another possibility is to issue a manual CHECKPOINT command as soon as
you've finished a bulk copy.
regards, tom lane