It's not that I expect a lot of improvement by having non-WAL indexing, it just sounds logical to me to have that, since index can be re-created fast enough during recovery, and it would reduce my IO to some extent. Alex. > Sorry, as I hit send, I realized I should clarify this: I do my bulk > loads with the indexes active; I don't rebuild them (as they're > necessary during the batch calculations). Dropping the indexes and > using test data didn't show a significant performance improvement over > leaving the indexes enabled. >
