Re: Performance

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