Do projections need to be optimized after every load?

No, projections are typically designed once, up front, before going to production. Once optimized projections exist, when a table is loaded, all associated projections physically store a copy of the loaded data. Projections are the only physical data storage format in Vertica and are maintained automatically.