| From: | Ryan Johnson <ryan(dot)johnson(at)cs(dot)utoronto(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: SSI slows down over time |
| Date: | 2014-04-15 01:57:43 |
| Message-ID: | 534C9217.4010308@cs.utoronto.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Borodin Vladimir | 2014-04-15 10:16:34 | Re: Checkpoint distribution |
| Previous Message | Nick Eubank | 2014-04-15 00:50:09 | Re: Tuning Postgres for Single connection use |