pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: 8 way Intel Xeon system
Date: Wed, 27 Aug 2003 12:30:33 +0530
Message-ID: <3F4CA469.27749.32D48FD@localhost> (raw)
In-Reply-To: <B09017B65BC1A54BB0B76202F63DDCCA053249BB@auntm201>

On 27 Aug 2003 at 14:07, Castle, Lindsay wrote:
> I'm mainly interested in what I should concentrate on from a
> Linux/PostgreSQL config point of view to see if we can take advantage of the
> extra CPUs. - Yes it's overkill but this is a piece of surplus hardware we
> don't have to buy.

First of all whatever you do, add multiple connections using a middle layer. 
That will keep your CPU busy. 

Of course there are few things need to be done over single connection but this 
should help at least in some scenarios.
 
> Perhaps some may say Linux isn't the best option for an 8 CPU server but
> this is what I have to work with for reasons we won't get into :-)

I think if you can afford a performance benchmark trial, give 2.6.0-testx a 
try. They should be much better than 2.4.x.
 
> The current usage is along the lines of a few thousands updates spread over
> the space of a few hours in the morning then followed by a thousand select
> queries to do some reporting.

In case of such IO intensive and update/delete heavy load, might be a good idea 
to move WAL to a separate SCSI channel. I believe merely moving it to another 
drive would not yield as much boost.

> Currently RedHat 9 with PostgreSQL 7.3.2 installed.

Get 7.4CVS head. and don't forget to use a autovacuum daemon. It's in contrib 
dir.

HTH

Bye
 Shridhar

--
Ogden's Law:	The sooner you fall behind, the more time you have to catch up.




view thread (5+ messages)  latest in thread

Message-ID: <3F4CA469.27749.32D48FD@localhost>
Permalink:  ../3F4CA469.27749.32D48FD@localhost/
Also on:    postgresql.org/message-id/3F4CA469.27749.32D48FD@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: 8 way Intel Xeon system
  In-Reply-To: <3F4CA469.27749.32D48FD@localhost>
  References: <B09017B65BC1A54BB0B76202F63DDCCA053249BB@auntm201> <3F4CA469.27749.32D48FD@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox