From: Ryan Johnson <ryan.johnson@cs.utoronto.ca>
To: pgsql-performance@postgresql.org
Subject: Re: SSI slows down over time
Date: Mon, 14 Apr 2014 21:57:43 -0400
Message-ID: <534C9217.4010308@cs.utoronto.ca> (raw)
In-Reply-To: <534C4580.40700@cs.utoronto.ca>
References: <1397484864.73109.YahooMailBasic@web122302.mail.ne1.yahoo.com>
<534C4580.40700@cs.utoronto.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 14/04/2014 4:30 PM, Ryan Johnson wrote:
> FYI, here's a plot of performance over time. Each point in the graph
> is throughput (in tps) over a 10-second measurement (~20 minutes
> total), against a 12 WH TPC-C dataset with 24 clients banging on it. I
> issued a pg_ctl stop/start pair between each run:
Updated result: SI definitely does not suffer any performance loss over
time, but it's not clear what is wrong with SSI: deleting pg_serial/*
had exactly zero impact on performance.
The two near-zero results for SSI are both cases where pg_serial/
ballooned to 8GB during the run (I saw two others tonight during
testing). The one big dip for SI was a hang (the second such hang tonight).
>
> Thoughts?
> Ryan
>
Attachments:aibadhjj.png (image/png, 15.2K) downloadview image
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: ryan.johnson@cs.utoronto.ca
Subject: Re: SSI slows down over time
In-Reply-To: <534C9217.4010308@cs.utoronto.ca>
* 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