| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Torsten Schulz <comic(at)be-a-part(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimize |
| Date: | 2003-11-25 02:24:45 |
| Message-ID: | 87fzgdnq1e.fsf@mailbox.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Torsten Schulz <comic(at)be-a-part(dot)de> writes:
> Our Server:
> Dual-CPU with 1.2 GHz
> 1.5 GB RAM
What kind of I/O subsystem is in this machine? This is an x86 machine,
right?
> Has anyone an idea what's the best configuration for thta server?
It is difficult to say until you provide some information on the
system's state during periods of heavy traffic.
BTW, in addition to the machine's hardware configuration, have you
looked at tuning the queries running on PostgreSQL? What about the OS
kernel?
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-11-25 02:27:40 | Re: VACUUM problems with 7.4 |
| Previous Message | Greg Stark | 2003-11-25 01:16:27 | Re: Maximum Possible Insert Performance? |