DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
 b=A9bXDol5R0IVvFIKcymWz06r3LJXUfcRinMqRKxnJHAOAWWyQ72JkRG8Dl9w+RDWTQpRQoyXcJHMko55yo/ioV0c3WM5pupIDT3Nz4rbhMyZJ/rP26TGcFoeDYHxIz6jH5Oi3GSytUuANJJ89V2avBAJb41aDr4dNPm8QrogV40=;
Message-ID: <1397484864.73109.YahooMailBasic@web122302.mail.ne1.yahoo.com>
Date: Mon, 14 Apr 2014 07:14:24 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: SSI slows down over time
To: pgsql-performance@postgresql.org,
 Ryan Johnson <ryan.johnson@cs.utoronto.ca>
In-Reply-To: <534BDB66.9020000@cs.utoronto.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Ryan Johnson <ryan.johnson@cs.utoronto.ca> wrote:

> every time I shut down a database and bring it back up, SSI seems
> to go slower.

There's one thing to rule out up front -- that would be a
long-lived prepared transaction.

Please post the output of these queries:

select version();
show max_prepared_transactions;
select * from pg_prepared_xacts;

Thanks.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance