It really does not matter what your tank size is or how much water you need, you still want a 75-90 GPD RO/DI system. The reason being it makes wate rmuch quicker so your faucet is not tied up for hours on end. A 90 GPD will make 10 gallons in 2.5-3 hours, the 40 GPD will have you faucet tied up for 6-7 hours to make the same amount. To save yourself time monitoring andchecking the buckets don't overfow and not being able to use that faucet for anything else a smaller GPD makes no sense. Again, the price is usually within $5-$10, all the replacement filters and resin are the same except the membrane and it is the same physical size since every canister is identical.
You do not have to make 90 gallons just because its a 90 GPD, you make what you need and shut it off.