| From: | Alex Hochberger <alex(at)feratech(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Tweaking on an OpenBSD Machine |
| Date: | 2001-05-21 18:42:10 |
| Message-ID: | 1F3774AB3688D4118B1300508BD9641528A818@CHINA |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm looking for help from someone that has run Postgres 7.1.1 on a highend
OpenBSD machine. We have LOTS of RAM (1.5GB) and we want to get Postgres to
use as MUCH as possible to speed things up. What kernel tweaks have you
applied? What login.conf changes have you made? What have you done to the
postgresql startup to make it use this RAM?
Also, in addition to what changes that you've made, what are the defaults,
what does it mean, etc? I need to get the system speedy (then I can use
EXPLAIN for further query tweaks) quickly, and I need to know what changes I
should make.
Alex
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-21 18:55:25 | Re: Memory usage and pg_dump |
| Previous Message | Peter Eisentraut | 2001-05-21 18:28:47 | RE: psql shell problem |