The Powerdns config is just simple .db files being pushed by the control panel, being like 1-5KB per zone. So hosting a million sites would be like 1-5GB. The bare V12 install with DNS role is like 9GB.
Probably the memory would be the first bottleneck, but a 25GB VPS with 2GB RAM should be able to handle a lot with just the DNS role.
