Re: Optimize - Mailing list pgsql-performance

From Neil Conway
Subject Re: Optimize
Date
Msg-id 87fzgdnq1e.fsf@mailbox.samurai.com
Whole thread Raw
In response to Optimize  (Torsten Schulz <comic@be-a-part.de>)
List pgsql-performance
Torsten Schulz <comic@be-a-part.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


pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Maximum Possible Insert Performance?
Next
From: Neil Conway
Date:
Subject: Re: VACUUM problems with 7.4