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

  1. Enable parallelism in REFRESH MATERIALIZED VIEW.