Right way of formatting extra drive

Hi,

I’m running Nextcloud on my Raspberry Pi 4 now, but I want to switch to an HP EliteDesk Ryzen miniPC. I have installed Debian and formatted the drive btrfs.

I have an open M.2 slot where I want to put 1TB extra memory. I read that for a database, btrfs is not the best choice, that ext4 is better. So Is it best to make the extra memory 2 partitions (since I don’t think I need 1TB for the database? I’m the only user of that Nextcloud-instance, using office, memories, calendar, contacts and files): part ext4 and part btrfs?

Something like 50GB for the database , the rest for data?