From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: spikes in pgbench read-only results
Date: Mon, 23 Jan 2012 00:17:18 +0100
Message-ID: <4F1C98FE.1030307@fuzzy.cz> (raw)
Hi,
I'm working on a benchmark that demonstrates the effects of moving
tables or indexes to separate devices (SSD and HDD), and one thing that
really caught my eye are spikes in the tps charts. See this:
http://www.fuzzy.cz/tmp/data-indexes/indexes.html
The first one is a database with data on an SSD and indexes on 7.2k HDD.
Around 2:00, the performance significantly grows (over 4k tps) and then
falls to about 500 tps (which is maintained for the remainder of the
benchmark).
I've seen similar spikes on HDD (both data and indexes on the same
device) - that's the second chart. The difference is not that huge, but
the spike at around 6:00 is noticeable.
Interestingly, by separating the data and indexes to two 7.2k drives,
the spike disappears - that's the third chart.
Any ideas why this happens? Is this a pgbench-only anomaly that does not
happen in real-world scenarios?
My theory is that it's related to the strategy that chooses what to keep
in shared_buffers (or page cache), and that somehow does not work too
well in this case.
regards
Tomas
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: tv@fuzzy.cz
Subject: Re: spikes in pgbench read-only results
In-Reply-To: <4F1C98FE.1030307@fuzzy.cz>
* 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