If you have no errors without :auto it means that you are on very old DataFrames.jl and I recommend you update it.
:auto does not give you compression. You can turn-on compression when writing file to disk (but most likely it might lead to slower write times, at the benefit of having smaller file size).