On 20/04/17 14:57, Peter Eisentraut wrote: > On 4/18/17 22:25, Petr Jelinek wrote: >> The commit 887227a1c changed the defaults for subscriptions to do async >> commit. But since the tests often wait for disk flush and there is no >> concurrent activity this has increased the amount of time needed for >> each test. So the attached patch changes the subscriptions create in tab >> tests to use sync commit which improves performance there (because we >> also replicate only very few transactions in the tests). > > I see only a 1.5% (1s/70s) improvement in the run time of the whole test > suite from this. Is that what you were expecting? >
Hmm, on my machine the difference is around 50% (~1m vs ~2m). -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
