On Tue, Dec 27, 2016 at 12:59 PM, Stas Kelvich <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
