"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > So would you set commit_fsync_delay on a per-transaction basis? That > doesn't make much sense to me... I guess I'm not seeing how you would > explicitly mark transactions that you didn't want to fsync immediately.
My assumption was that most of the time you'd want this behavior per-session and so the existing mechanisms for setting a GUC variable would work perfectly well. If you really want it per-transaction then changing the variable on the fly is possible (perhaps using SET LOCAL). You'll be issuing nonstandard commands either way... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org