pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: markw@osdl.org
To: pgman@candle.pha.pa.us
Cc: pgsql-performance@postgresql.org
Cc: osdldbt-general@lists.sourceforge.net
Subject: Re: analyzing postgresql performance for dbt-2
Date: Wed, 29 Oct 2003 14:26:11 -0800 (PST)
Message-ID: <200310292226.h9TMQEC26620@mail.osdl.org> (raw)
In-Reply-To: <200310260436.h9Q4a9f09899@candle.pha.pa.us>

I've done a better controlled series of tests where I restore the
database before each test and have grabbed sar and oprofile data:

http://developer.osdl.org/markw/dbt2-pgsql/176/
	- load of 100 warehouses
	- metric 1234.52

http://developer.osdl.org/markw/dbt2-pgsql/177/
	- load of 120 warehouses
	- metric 1259.43

http://developer.osdl.org/markw/dbt2-pgsql/178/
	- load of 140 warehouses
	- metric 1244.33

For the most part our primary metric, and the vmstat and sar output look
fairly close for each run.  Here are a couple of things that I've found
to be considerably different from run 176 to 178:

- oprofile says postgresql calls to SearchCatCache increased ~ 20%

- readprofile says there are 50% more calls in the linux kernel to
  do_signaction (in kernel/signal.c)

Would these two things offer any insight to what might be throttling the
throughput?

Thanks,
Mark





view thread (6+ messages)

Message-ID: <200310292226.h9TMQEC26620@mail.osdl.org>
Permalink:  ../200310292226.h9TMQEC26620@mail.osdl.org/
Also on:    postgresql.org/message-id/200310292226.h9TMQEC26620@mail.osdl.org

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markw@osdl.org, pgman@candle.pha.pa.us, osdldbt-general@lists.sourceforge.net
  Subject: Re: analyzing postgresql performance for dbt-2
  In-Reply-To: <200310292226.h9TMQEC26620@mail.osdl.org>

* 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