pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guillaume Smet <guillaume.smet@gmail.com>
To: pgsql-performance@postgresql.org
Subject: PostgreSQL and Xeon MP
Date: Thu, 16 Mar 2006 11:45:12 +0100
Message-ID: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com> (raw)

Hello,

We are experiencing performances problem with a quad Xeon MP and
PostgreSQL 7.4 for a year now. Our context switch rate is not so high
but the load of the server is blocked to 4 even on very high load and
we have 60% cpu idle even in this case. Our database fits in RAM and
we don't have any IO problem. I saw this post from Tom Lane
http://archives.postgresql.org/pgsql-performance/2004-04/msg00249.php
and several other references to problem with Xeon MP and I suspect our
problems are related to this.
We tried to put our production load on a dual standard Xeon on monday
and it performs far better with the same configuration parameters.

I know that work has been done by Tom for PostgreSQL 8.1 on
multiprocessor support but I didn't find any information on if it
solves the problem with Xeon MP or not.

My question is should we expect a resolution of our problem by
switching to 8.1 or will we still have problems and should we consider
a hardware change? We will try to upgrade next tuesday so we will have
the real answer soon but if anyone has any experience or information
on this, he will be very welcome.

Thanks for your help.

--
Guillaume



view thread (17+ messages)  latest in thread

Message-ID: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com>
Permalink:  ../1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com/
Also on:    postgresql.org/message-id/1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com

 · 

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: guillaume.smet@gmail.com
  Subject: Re: PostgreSQL and Xeon MP
  In-Reply-To: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com>
  References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com>

* 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