Jason Ralph <jralph@xxxxxxxxxxxxxxxxxxxxx> writes: > I wanted to drop a quick note thanking the developers who have > contributed to Postgres. I have recently upgraded our production PG > instances from pg9.3 to pg11. > > We do a lot of table syncs, and we have one process at the end of the > month that syncs 3 very large tables (400GB). This sync happens from > a shell script using pg_dump and pg_restore, we have it set to use -j3 > but it's called sequentially so it never really takes advantage of > parallel. > > Since pg11 on both the target and source, the run time has decreased a > lot, I chalk it up to the parallel index creations in pg11 which was a > very time consuming process on pg9.3. > The process has finished almost 10 hours earlier than pg93. So thank > you for your hard work and dedication to this awesome piece of > software. This is a great user story. Thanks for sharing your experience, Jason. -- Pankaj Jangid
