Re: SSI slows down over time - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: SSI slows down over time
Date
Msg-id 20140409212105.GF8686@momjian.us
Whole thread Raw
In response to Re: SSI slows down over time  (Ryan Johnson <ryan.johnson@cs.utoronto.ca>)
Responses Re: SSI slows down over time  (Ryan Johnson <ryan.johnson@cs.utoronto.ca>)
List 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-performance by date:

Previous
From: Robert Burgholzer
Date:
Subject: Re: Optimizing Time Series Access
Next
From: Ryan Johnson
Date:
Subject: Re: SSI slows down over time