> We only have about 5.5-6GB of actual data in our dbmail database, > but usage keeps growing over time, eventually filling the 18GB > available disk space. We ended up running periodic vacuum fulls > from cronjobs (twice a month lately), and that does drop the used > disk space down some, but it does continue to grow. As of this > weekend, after running a vacuum full, still had > 16GB taken up for > postgres. Last night we did a dump of all databases, dropped and > recreated them, and are now inserting back in... not done yet, so > I can't give the total end result, but the dump file itsself is > only 4.8GB.
FTR, with all data back in and indexes recreated, we're right at 5.8 GB for dbmail (6.3GB total with other databases). -- Jesse Norell [EMAIL PROTECTED] is not my email address; change "administrator" to my first name. --