There’s absolutely no limit. Some hosting providers add arbitrary limits but even the entire Bitcoin header tree in DNS records running in BIND is like 1G of memory…

https://bitcoinheaders.net/