{"id":6680,"date":"2020-11-16T11:45:23","date_gmt":"2020-11-16T04:45:23","guid":{"rendered":"http:\/\/gcloudvn.wam.vn\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/"},"modified":"2023-04-13T10:10:47","modified_gmt":"2023-04-13T03:10:47","slug":"google-cloud-sql-nay-da-ho-tro-postgresql-13","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/","title":{"rendered":"Google Cloud SQL now supports PostgreSQL 13"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Today, Google announced that <\/span><a href=\"https:\/\/gcloudvn.com\/en\/cloud-sql\/\"><span style=\"font-weight: 400;\">Cloud SQL<\/span><\/a><span style=\"font-weight: 400;\">, our fully managed database service for PostgreSQL, MySQL, and SQL Server, now supports <\/span><span style=\"font-weight: 400;\">PostgreSQL 13<\/span><span style=\"font-weight: 400;\">. With the soon-to-be-announced PostgreSQL 13, you&#039;ll have access to the latest PostgreSQL features while letting Cloud SQL handle the hard work, so your team can focus on developing applications that deliver many benefits for customers.<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17753\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/11\/NEws-4-e1605501779512-1024x585.jpg\" alt=\"Google Cloud SQL now supports PostgreSQL 13 \" width=\"757\" height=\"433\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\"><strong>PostgreSQL 13<\/strong> delivers performance improvements across the board, including enhanced partitioning, increased indexing and efficiency, and better scaling monitoring. Here are some new feature highlights:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><b>Supports additional partitioning and truncation scenarios:<\/b><span style=\"font-weight: 400;\"> As part of the ongoing enhancements of partitioned tables in the two most recent versions of PostgreSQL, new cases of partition truncation and direct joins were introduced, including joins between Data tables are partitioned when their partition limits do not match exactly. Additionally, enabling BEFORE on partitioned tables is now supported.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Sort up ascending: <\/b><span style=\"font-weight: 400;\">Organizing is a performance-intensive job, so any improvement in this area can make a difference. Now, PostgreSQL 13 introduces ascending sorting, which supports early-stage query types and sorts only unsorted fields ascending, increasing the likelihood that the sorted block will fit in memory and thus, improving performance.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Aggregate Hash data effectively: <\/b><span style=\"font-weight: 400;\">In previous versions, during the planning phase, the Hasg data aggregation function was usable or not, depending on whether the Hash table fit in memory or not. With the new version, Hash aggregation can be determined based on cost analysis, regardless of the amount of space in memory.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>B-tree index: <\/b><span style=\"font-weight: 400;\">now works more efficiently thanks to storage reduction enabled by removing duplicate values.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Empty: <\/b><span style=\"font-weight: 400;\">is a necessary operation for database performance, especially for important and demanding workloads. It reclaims the space occupied by dead datasets and catalogs it in a visibility map for future use. In PostgreSQL 13, advanced automation and performance improvements are being introduced:<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><b>Empty faster<\/b><span style=\"font-weight: 400;\">: Parallel emptying of multiple indexes reduces the time taken to perform data cleanup.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>Automatically empty<\/b><span style=\"font-weight: 400;\">: Autovacuum can now be triggered by insert commands (in addition to the existing update and delete commands), ensuring the overview visibility is always updated promptly. This allows for better tuning of main memories while they remain in cache.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\"><b>Monitoring capabilities: <\/b><span style=\"font-weight: 400;\">WAL usage visibility in EXPLAIN, advanced logging options, new system views to monitor shared memory and LRU cache usage, etc.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Additional <\/span><b>WITH TIES<\/b><span style=\"font-weight: 400;\"> enter <\/span><b>FETCH FIRST<\/b><span style=\"font-weight: 400;\">: To ease paging, simplify processing, and reduce the number of statements, FETCH FIRST WITH TIES returns any additional rows tied to the last position in the result set by the ORDER BY clause.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cloud SQL helps ensure you can benefit from what PostgreSQL 13 has to offer quickly and securely. With automatic patches and updates, as well as maintenance controls, you can reduce the risks associated with upgrades and the latest minor version updates.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To support high-volume enterprise workloads, this edition is also fully integrated with the latest Cloud SQL features, including IAM database authentication for enhanced security, audit logging to meet compliance and point-in-time recovery requirements for better data protection.<\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/#Xac_thuc_co_so_du_lieu_voi_IAM\" >Database authentication with IAM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/#Audit_logging\" >Audit logging<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/#Point-in-time_recovery\" >Point-in-time recovery<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/google-cloud-sql-nay-da-ho-tro-postgresql-13\/#Bat_dau_voi_PostgreSQL_13\" >Get started with PostgreSQL 13<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Xac_thuc_co_so_du_lieu_voi_IAM\"><\/span><strong>Database authentication with IAM<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Integrate PostgreSQL with <\/span><span style=\"font-weight: 400;\">Cloud Identity and Access Management (Cloud IAM<\/span><span style=\"font-weight: 400;\">) simplifies user management and authentication by using the same Cloud IAM credentials instead of traditional database passwords.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Cloud SQL IAM database authentication unifies the authentication process, allowing administrators to track and manage user access easily and simply. This approach provides more consistency when integrating with database services <a href=\"https:\/\/gcloudvn.com\/en\/google-cloud-platform\/\">GCP<\/a> other, especially for environments that require multiple scales and complex environments.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Audit_logging\"><\/span><strong>Audit logging<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Audit logging is now enabled in Cloud SQL for companies required to comply with certifications, government, financial or ISO requirements. Extension <\/span><span style=\"font-weight: 400;\">pgaudit<\/span><span style=\"font-weight: 400;\"> allows you to create audit logs at the level of detail needed for future audit or investigation purposes. It gives you the flexibility to control logged statements by setting up configurations to specify which classes of statements should be logged.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Point-in-time_recovery\"><\/span><strong>Point-in-time recovery<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Point-in-time recovery<\/span><span style=\"font-weight: 400;\"> (PITR) helps administrators restore and restore an instance at a specific point in time using backups and WAL files when human error or vandalism occurs. PITR provides an additional method of data protection and allows you to restore your instance to a new version at any time in the last seven days. PITR is enabled by default when you create a new PostgreSQL 13 instance on Cloud SQL.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau_voi_PostgreSQL_13\"><\/span><strong>Get started with PostgreSQL 13<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To deploy the new PostgreSQL 13 instance using Cloud SQL, simply select PostgreSQL 13 from the drop-down menu on the database instance menu:<\/span><\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-17752 size-full\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2020\/11\/News-3.png\" alt=\"Google Cloud SQL now supports PostgreSQL 13 (2)\" width=\"425\" height=\"600\" \/><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">To learn more about Cloud SQL for PostgreSQL 13, see <\/span><a href=\"https:\/\/cloud.google.com\/sql\/docs\/postgres\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">Google documents<\/span><\/a><span style=\"font-weight: 400;\">. Cloud SQL will continue to ensure that you have access to the latest versions, while continuing to provide the best availability, security, and integration to meet your needs. Stay tuned for more updates on all Google Cloud database engines.<\/span><\/p>\n<p style=\"text-align: right;\"><strong>Source: <a href=\"https:\/\/gcloudvn.com\/en\/\">Gimasys<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>H\u00f4m nay, Google th\u00f4ng b\u00e1o r\u1eb1ng Cloud SQL, d\u1ecbch v\u1ee5 c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c qu\u1ea3n l\u00fd \u0111\u1ea7y \u0111\u1ee7 c\u1ee7a ch\u00fang t\u00f4i cho PostgreSQL, MySQL v\u00e0 SQL Server, hi\u1ec7n h\u1ed7 tr\u1ee3 PostgreSQL 13. V\u1edbi PostgreSQL 13 s\u1eafp \u0111\u01b0\u1ee3c c\u00f4ng b\u1ed1,&hellip;<\/p>","protected":false},"author":1,"featured_media":6681,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6680","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=6680"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/6680\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/6681"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=6680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=6680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=6680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}