Skip site navigation (1) Skip section navigation (2)

Re: Optimize

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 (view raw or flat)
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


In response to

  • Optimize at 2003-11-24 20:48:22 from Torsten Schulz

pgsql-performance by date

Next:From: Neil ConwayDate: 2003-11-25 02:27:40
Subject: Re: VACUUM problems with 7.4
Previous:From: Greg StarkDate: 2003-11-25 01:16:27
Subject: Re: Maximum Possible Insert Performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group