guys im using the pgvector extension and

guys im using the pgvector extension and am about to onboard a large client with 10.000s of files. So far I've only had to deal with 100s of files and 10.000s of chunks. Will I know have to worry about partitioning etc or does neon.tech do some magic for me handling this number of files/chunks? And if not timescale seems to claim some major scalability benefits. Would they be a better vendor?