Re: SSI slows down over time

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Ryan Johnson <ryan(dot)johnson(at)cs(dot)utoronto(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SSI slows down over time
Date: 2014-04-09 21:21:05
Message-ID: 20140409212105.GF8686@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 7, 2014 at 10:38:52AM -0400, Ryan Johnson wrote:
> The two * entries were produced by runs under SI, and confirm that
> the rest of the system has not been slowing down nearly as much as
> SSI. SI throughput dropped by 5% as the database quadrupled in size.
> SSI throughput dropped by 23% during the same interval. And this was
> actually one of the better sets of runs; I had a few last week that
> dipped below 1ktps.
>
> I'm not sure what to make of this, thoughts?

Seems it is time to ask on hackers.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cora Ma 2014-04-11 07:29:42 Re: performance degradation after launching postgres cluster using pgpool-II
Previous Message Robert Burgholzer 2014-04-09 19:48:57 Re: Optimizing Time Series Access