How about for speeding up many inserts?
At 12:13 AM 7/22/2003 -0400, Tom Lane wrote:
AFAIR you cannot force the system to have only one WAL segment; it *will* make another one when it has to.
Once it has established a checkpoint within the current WAL segment, it is able to delete the previous segment, and will do so if you've set the WAL parameters that small. I don't really recommend doing so however. Creating and deleting WAL segments is expensive, and not very productive compared to recycling them. The out-of-the-box settings allow the system to recycle three or so WAL segments. Unless you're truly desperate for disk space you should not reduce the default WAL settings.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
