PolarDB-for-PostgreSQL icon indicating copy to clipboard operation
PolarDB-for-PostgreSQL copied to clipboard

WIP: parallel acceleration of materialized view creation

Open pyh4 opened this issue 3 years ago • 5 comments

Use PolarDB PG's HTAP ability to accelerate materialized view creation.

Optimizer in PolarDB PG can generate MPP execution plan for qualifying SQLs, enabling concurrent execution of such a plan across multiple PolarDB PG instances. Utilize this ability to generate a MPP execution plan for materialized view creation.

relate to #247

pyh4 avatar Jul 24 '22 09:07 pyh4

Hi @pyh4 ~ Congratulations to your first PR to PolarDB. 🎉

Please make sure that your PR conforms the standard, and has passed all the checks.

We will review your PR as soon as possible.

polardb-bot[bot] avatar Jul 24 '22 09:07 polardb-bot[bot]

@pyh4 , Let's create some small targets:

  • [ ] Creating materialized views with MPP reading
  • [ ] Creating materialized views with MPP writing
  • [ ] Benchmarking

mrdrivingduck avatar Jul 24 '22 09:07 mrdrivingduck

Hey @pyh4 :

Congratulations~ 🎉 Your commit has passed all the checks. Please wait for further manual review.

polardb-bot[bot] avatar Jul 24 '22 10:07 polardb-bot[bot]

Hey @pyh4 :

Congratulations~ 🎉 Your commit has passed all the checks. Please wait for further manual review.

polardb-bot[bot] avatar Aug 01 '22 08:08 polardb-bot[bot]

Let's rebase all of the commit into a single one. @pyh4

mrdrivingduck avatar Sep 06 '22 01:09 mrdrivingduck

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Nov 22 '22 06:11 CLAassistant

Hey @pyh4 :

Congratulations~ 🎉 Your commit has passed all the checks. Please wait for further manual review.

polardb-bot[bot] avatar Dec 14 '22 08:12 polardb-bot[bot]

@pyh4 Nice feature~ I have no more comments. Thanks for your contribution!

mrdrivingduck avatar Dec 14 '22 10:12 mrdrivingduck

/rebase-and-merge

mrdrivingduck avatar Dec 14 '22 10:12 mrdrivingduck

@mrdrivingduck PR has been merged. 🍗

Thanks again for the contributors involved in this thread: ❤️

  • @pyh4

polardb-bot[bot] avatar Dec 14 '22 10:12 polardb-bot[bot]