October 26, 2020 By Traci Parker
Wei Jun Zheng
Horst Hummel
< 1 min read

IBM Cloud® Hyper Protect DBaaS for PostgreSQL now supports changing some of the PostgreSQL configuration settings so you can tune your PostgreSQL databases to your use case.

Currently, the available configuration settings are as follows:

  • shared_buffers: Shared memory buffers that the server use. The recommended memory allocation for shared_buffers is 1/4 of the service instance’s RAM.
  • max_locks_per_transaction: The setting controls the average number of object locks allocated for each transaction. Increase it only if you have queries that touch many different tables in a single transaction.
  • deadlock_timeout: The number of milliseconds to wait before checking for deadlock and the duration where lock waits are logged. Setting this number too low negatively impacts performance.

You can use the Hyper Protect DBaaS CLI or API to change the configuration. If the request to change configuration settings fails, the Hyper Protect DBaaS for PostgreSQL SRE team will be notified automatically. You can also use the CLI commands or API requests to view the change request status.

For more information and detailed instructions, see Changing the PostgreSQL configuration.

More about IBM Cloud Hyper Protect DBaaS

IBM Cloud Hyper Protect DBaaS offers a highly secure and managed databases — including PostgreSQL and MongoDB Enterprise Server — and provides a high level of data confidentiality for your sensitive data in the IBM Cloud.

Go to the IBM Cloud Catalog to try out the 30-day free plan for Hyper Protect DBaaS. You can choose between two database options:

Check out the Getting Started with IBM Cloud Hyper Protect DBaaS and Bring Your Own Key to IBM Cloud Hyper Protect DBaaS videos in the IBM Demos Collection.

Consult the Hyper Protect DBaaS for PostgreSQL documentation or the Hyper Protect DBaaS for MongoDB documentation for details on how to get started.

More from Cloud

How a US bank modernized its mainframe applications with IBM Consulting and Microsoft Azure

9 min read - As organizations strive to stay ahead of the curve in today's fast-paced digital landscape, mainframe application modernization has emerged as a critical component of any digital transformation strategy. In this blog, we'll discuss the example of a fictional US bank which embarked on a journey to modernize its mainframe applications. This strategic project has helped it to transform into a more modern, flexible and agile business. In looking at the ways in which it approached the problem, you’ll gain insights…

Attention new clients: exciting financial incentives for VMware Cloud Foundation on IBM Cloud

4 min read - New client specials: Get up to 50% off when you commit to a 1- or 3-year term contract on new VCF-as-a-Service offerings, plus an additional value of up to USD 200K in credits through 30 June 2025 when you migrate your VMware workloads to IBM Cloud®.1 Low starting prices: On-demand VCF-as-a-Service deployments begin under USD 200 per month.2 The IBM Cloud benefit: See the potential for a 201%3 return on investment (ROI) over 3 years with reduced downtime, cost and…

24 IBM offerings winning TrustRadius 2024 Top Rated Awards

2 min read - TrustRadius is a buyer intelligence platform for business technology. Comprehensive product information, in-depth customer insights and peer conversations enable buyers to make confident decisions. “Earning a Top Rated Award means the vendor has excellent customer satisfaction and proven credibility. It’s based entirely on reviews and customer sentiment,” said Becky Susko, TrustRadius, Marketing Program Manager of Awards. Top Rated Awards have to be earned: Gain 10+ new reviews in the past 12 months Earn a trScore of 7.5 or higher from…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters