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. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
