From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance
Date: Fri, 24 May 2013 08:21:31 -0400
Message-ID: <519F5B4B.5010101@2ndQuadrant.com> (raw)
In-Reply-To: <CA+N_YAdDUXkzX9Z5p0G7An_f-=gc8p2ePJe4_aDijWAFQzwYWQ@mail.gmail.com>
References: <CA+N_YAdDUXkzX9Z5p0G7An_f-=gc8p2ePJe4_aDijWAFQzwYWQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 5/23/13 7:39 AM, Sachin D. Bhosale-Kotwal wrote:
> So i am not getting why spike occure at *12:09:14 *only*.*
This could easily be caused by something outside of the test itself.
Background processes. A monitoring system kicking in to write some data
to disk will cause a drop like this.
Three things you could look into to try and track down the issue:
-Did you turn on log_checkpoints to see if one happens to run when the
rate drops? If so, that could be the explanation. Looks like you setup
the test to make this less likely, but checkpoints are tough to
eliminate altogether.
-Does this happen on every test run? Is it at the same time?
-You can run "top -bc" to dump snapshots of what the system is doing
every second. With some work you can then figure out what was actually
happening during the two seconds around when the throughput dropped.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: greg@2ndQuadrant.com
Subject: Re: pgbench: spike in pgbench results(graphs) while testing pg_hint_plan performance
In-Reply-To: <519F5B4B.5010101@2ndQuadrant.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