![]() ALTER EXTENSION extension_name UPDATE TO ‘new_version’ Issues Use the below command to upgrade your extensions. As PostgreSQL engine upgrade doesn’t upgrade most of the PostgreSQL extensions. Once the ANALYZE is completed, Upgrade your extensions. ANALYZE -> This will be run on available tables in the current schema that the user has access to.ģ. This command will help the planner to choose the most appropriate query plan, and thereby improve the speed of query processing. Once REINDEX is completed, Run ANALYZE.ĪNALYZE gathers statistics for the query planner to create the most efficient query execution paths. Recreate all indices in the database -> REINDEX DATABASE database_nameĢ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |