A database file 1.6Gb in size will start to behave badly once you start running queries on the largest tables, as it will be attempting to create temporary objects during that query process that will make it approach the 2Gb file size limit.
You used a group by in your delete query, that won't...