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.
>