Add the following line to
/etc/pihole/pihole-FTL.conf (create this file if it does not exist):
to completely disable the database.
Note that daily logs will still happen unless you have logging turned off. But these will not be saved to the long-term stats database.
For more information see https://docs.pi-hole.net/ftldns/database/