Ryan Johnson <ryan(dot)johnson(at)cs(dot)utoronto(dot)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