add clean cache function in pg_prewarm

ApsaraDB / PolarDB-for-PostgreSQL

A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

https://apsaradb.github.io/PolarDB-for-PostgreSQL/zh/

Apache License 2.0

2.89k stars 481 forks source link

add clean cache function in pg_prewarm #457

Closed csuopen closed 11 months ago

csuopen commented 11 months ago

When we use pg_prewarm to cache a table into memory, we need to clean up the cache again when we need to see the results, so we added two functions:

The function pg_clean_all_cache cleans up all the cache of the current database.
The function pg_clean_rel_cache to clean up the cache of a table.

CLAassistant commented 11 months ago

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
_{You have signed the CLA already but the status is still pending? Let us recheck it.}

polardb-bot[bot] commented 11 months ago

Hi @csuopen ~ Thanks for your contribution in this PR. ❤️

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] commented 11 months ago

Hey @csuopen :

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

csuopen commented 11 months ago

mistake something, PR should not be to ApsaraDB:POLARDB_11_STABLE, need to DEV branch. so close is, and create new pr to dev branch.