| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Performance |
| Date: | 2003-08-07 20:59:22 |
| Message-ID: | 200308071359.22728.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Hurst | 2003-08-08 09:29:37 | Query about Boolean Data Type |
| Previous Message | Jodie | 2003-08-07 20:53:36 | Upgrading from 7.1.3 to 7.2.3 |