Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?
Philip Semanchuk <philip@americanefficient.com>
From: Philip Semanchuk <philip@americanefficient.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Vijaykumar Jain <vijaykumarjain.github@gmail.com>,
Tom Lane <tgl@sss.pgh.pa.us>,
PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2021-06-02T12:39:33Z
Lists: pgsql-general
> On Jun 1, 2021, at 3:23 PM, Thomas Munro <thomas.munro@gmail.com> wrote: > > On Wed, Jun 2, 2021 at 7:15 AM Vijaykumar Jain > <vijaykumarjain.github@gmail.com> wrote: >> i only get workers to create mv, but refresh mv plan does not use workers for the same conf params. > > Yeah, this changed in v14: > > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9e7ccd9ef64d05e87ceb1985d459bef9031205c0 Thanks, all! It’s great to have a clear explanation. I looked at the change notes for 12 & 13 before I posted. I didn’t occur to me to look at 14. :-) Cheers Philip
Commits
-
Enable parallelism in REFRESH MATERIALIZED VIEW.
- 9e7ccd9ef64d 14.0 cited