Re: SSI slows down over time

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-14 12:59:02
Message-ID: 534BDB96.9020507@cs.utoronto.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 09/04/2014 5:21 PM, Bruce Momjian wrote:
> 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.
Ack.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Murphy, Kevin 2014-04-14 13:55:59 Re: Ye olde slow query
Previous Message Ryan Johnson 2014-04-14 12:58:14 SSI slows down over time