> Try: > select count(*) from dbmail_partlists left join dbmail_physmessage on > (dbmail_physmessage.id=dbmail_partlists.physmessage_id) where > dbmail_physmessage.id is null; > > That should confirm if there are any parts being left there. Count=0 > means no leftovers, Count>0 then there are extra parts not being cleaned > up. Perhaps a constraint was missed, or maybe you just need to optimize > all of the tables to regain the space.
The count(*) result is zero, anyway rows are still available in mentioned tables, as listed :/ P. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
