Ryan Johnson <ryan.johnson@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance