pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Buchan <sbuchan@technicacorp.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql performance on Solaris
Date: Tue, 01 Apr 2003 15:21:43 -0500
Message-ID: <2851.1049228503@sss.pgh.pa.us> (raw)
In-Reply-To: <71F044551C53974EB0735B3737EFE2FC088645@wwwserver>
References: <71F044551C53974EB0735B3737EFE2FC088645@wwwserver>

"Scott Buchan" <sbuchan@technicacorp.com> writes:
> I am getting poor performance from my postgresql (version 7.3.2 compiled
> with gcc 2.95.2) database when running load tests on my web application.
> The database works great until I get above 200 concurrent users.

Hmm ... that sounds kinda familiar; you might check the archives for
similar reports from Solaris users.  AFAIR we didn't figure out the
problem yet, but there's some raw data available.

> When running the load tests, the cpu of the box is always above 60%
> idle.  I have run iostat and I am not seeing any problems with io.

[ scratches head ... ]  If the bottleneck isn't CPU, and it isn't I/O,
then what could it be?  You sure about the above observations?  (Does
iostat include swap activity on that platform?)

The only other idea I can think of is that there's some weird effect in
the locking code (which only shows up with lots of concurrent backends)
such that would-be lockers repeatedly fail and sleep when they should
have gotten the lock.  If you can figure out how to tell the difference
between a backend waiting for disk I/O and one waiting for a semaphore
or sleeping, it'd be interesting to see what the majority of the
backends are doing.

Another way to try to gather some data is to attach to one of the
backend processes with a debugger, and just stop it to get a stack trace
every so often.  If the stack traces tend to point to the same place
that would give some info about the bottleneck.

			regards, tom lane




view thread (3+ messages)  latest in thread

Message-ID: <2851.1049228503@sss.pgh.pa.us>
Permalink:  ../2851.1049228503@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2851.1049228503@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, sbuchan@technicacorp.com
  Subject: Re: Postgresql performance on Solaris
  In-Reply-To: <2851.1049228503@sss.pgh.pa.us>
  References: <71F044551C53974EB0735B3737EFE2FC088645@wwwserver> <2851.1049228503@sss.pgh.pa.us>

* 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