A while back someone asked about using dbmail with pgsql 9.0. I started testing it last night.
I added: bytea_output = 'escape' to my .../postgresql/9.0/data/postgresql.conf; I didn't check whether the 2_2 branch has support for hex-encoded byteas (I understand that dbmail trunk does handle bytea_output='hex'). Otherwise my config matches my 8.4 config. It works fine. Any db is always faster just after a restore, so the fact that things are snappier today is no surprise. But 9.0 does make better use of its shared mem. Even after significant usage it is only up to 57 Megs shared. That is perhaps a quarter of what I'd expect 8.4 to require for the same usage pattern. With the indices fully cached imap EXAMINEs of a large number of groups are no faster than in 8.4 (about 20/second with DDR3 1333 and a 2×64bit mem controller) but I expect the reduced shared pressure to allow larger sites to retain fully cached indices for a given ram size. Postfix and dspam also work well with 9.0. -JimC -- James Cloos <[email protected]> OpenPGP: 1024D/ED7DAEA6 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
