I don't know yet, but that's why I bought the SD Card earlier; to not delay anything.
The PS Vita already allows people to download full retail games, and the heaviest game at the moment, is Uncharted: Golden Abyss (2,2 GB).
I only have a 4 GB Memory Card in my PS Vita, so I've bought Uncharted in retail package instead, but there's a 32 GB Memory Card for it on my way now.
There are even 64 GB and 128 GB SD Cards nowadays, but they can't be read by any 3DS, nor Wii, nor DSi.
I doubt the DSi and Wii will ever get support for them, but an update for the 3DS, is very likely.
Why they aren't supported?
Because the 'normal' SD Cards go up to 2 GB, while SDHC Cards go from 4 GB to 32 GB.
Starting from 64 GB, it's called "SDXC", which is so new, there isn't much support on today's devices yet.