On Tue, Dec 27, 2016 at 12:59 PM, Stas Kelvich <s.kelv...@postgrespro.ru> wrote: > Standard config with increased shared_buffers. I think the most significant > impact on the recovery speed here is on the client side, namely time between > prepare and commit. Right now I’m using pgbench script that issues commit > right after prepare. It’s also possible to put sleep between prepare and > commit > and increase number of connections to thousands. That will be probably the > worst case — majority of prepared tx will be moved to files.
I think that it would be a good idea to actually test that in pure recovery time, aka no client, and just use a base backup and make it recover X prepared transactions that have created Y checkpoints after dropping cache (or restarting server). -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
