Keeping data from all tx indexed entails a large memory footprint during all client use. The checkpoint issue affects only the initial sync. Making that trustless by turning off the checkpointing makes turns a moderately slow sync into an extremely slow sync.