Hello all, I'm in serious need of help here. I'm about at my whits end of dealing with dbmail and getting it to work. I've had a couple of database crashes now and found things like if I run dbmail-util my DB process load skyrockets and the server becomes unusable.
I'm hoping that maybe I'm just incapable of tuning PostgreSQL for performance. At this point I'd like to know if there is anyone out there that has experience with dbmail-2.0.4 on PostgreSQL-7.4.7 in a moderately large table size (9-10GB). We are very interested in paying for some help in the form of consulting if need be. At this point if we can't work out the bugs then we are going to scrap the entire thing and go back to our simple Windows based NTMail system. Some items that seems to happen are: 1) If I stop/reload the postgres database (normal nice stop which should allow all transactions to finish) the dbmail master daemon dies and we seem to get a lot of unconnected messages suddenly in the database. We see these in the form of no user, no subject messages in users mailboxes. 2) When dbmail-util runs, the process load just sky rockets on the db server. It seems to be related to the large join done for finding the messageblks that are not connected. 3) When we vacuum the database the process load screams sky high (like 160+) on the server. The last time we did this it took 4 days for the vacuum to finish. We believe we have this fixed by using the pg_autovacuum daemon. Our set up is: DB Server - Dual Xeon 3.06GHz, 1GB RAM, SCSI RAID Ultra320 drives. DBMail Server - P4 3.06GHz, 1GB RAM, SATA drives. Running: dbmail-2.0.4, postgresql-7.4.7 on Gentoo with Linux 2.6 kernel As far as tweaking goes, I've set sort_mem and vacuum_mem on postgres to each 100M (102400) to help try and stop swaps. I've also increased the shared memory limit from 32M to 100M. I'd also be very interested in knowing a better way to limit the database transaction logs such that should I suffer a crash I'm not having to dump the database and restore. I never really had this issue with MSSQL. I expect to lose things like the message that is being delivered, but not corrupt the dbmail_users table and everything else. HELP... TIA -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/
