Horton

Re: CREATE/REFRESH MATERIALIZED VIEW planner difference?

Thomas Munro <thomas.munro@gmail.com>

View thread View on postgr.es
From: Thomas Munro <thomas.munro@gmail.com>
To: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Philip Semanchuk <philip@americanefficient.com>, PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2021-06-01T19:23:11Z
Lists: pgsql-general 
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

Commits

  1. Enable parallelism in REFRESH MATERIALIZED VIEW.