skytools-legacy icon indicating copy to clipboard operation
skytools-legacy copied to clipboard

Published 20 hours ago • verified publisher icon pgq

londiste.repair: add option to dump in parallel

Open tarvip opened this issue 9 years ago • 3 comments

tarvip avatar Sep 02 '15 14:09 tarvip

@tarvip , hello! Could you please explain what does the option --parallel do? Why is it convenient to have this option at our disposal?

yesnik avatar Feb 02 '16 11:02 yesnik

This is used by repair. When tables are repaired then source and target tables are dumped to disk and then these dumps are compared later. Without --parallel option tables are dumped in serial. First source is dumped then target. Downside is that if you have large table then transaction on target can be opened for a long time as it is opened before starting source dump. With --parallel option source and target dumps are created at the same time.

tarvip avatar Feb 02 '16 12:02 tarvip

Thank you, Tarvi ( @tarvip ), I got it. This option will be very helpful for us. Marko ( @markokr ), hello! Is it possible to merge this pull request into master?

yesnik avatar Feb 02 '16 13:02 yesnik