Bryan,
> I've read that disabling fsync, setting buffer size, crontabbing vacuum,
> and vacuum analyze, as well as raising the amount of time between
> checkpoint runs helps. I haven't read what I should set some of these
> values to. How high should buffer and cache size be? how high should I
> raise the checkpoint? Any other tips?
Two:
Join the PGSQL-PERFORMANCE mailing list for more help.
Read http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
... if you have not already
--
-Josh Berkus
Aglio Database Solutions
San Francisco