Re: PG11 Parallel Thanks!!

Jason Ralph <jralph(at)affinitysolutions(dot)com> 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