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

A clear path to value: Overcome challenges on your FinOps journey 

3 min read - In recent years, cloud adoption services have accelerated, with companies increasingly moving from traditional on-premises hosting to public cloud solutions. However, the rise of hybrid and multi-cloud patterns has led to challenges in optimizing value and controlling cloud expenditure, resulting in a shift from capital to operational expenses.   According to a Gartner report, cloud operational expenses are expected to surpass traditional IT spending, reflecting the ongoing transformation in expenditure patterns by 2025. FinOps is an evolving cloud financial management discipline…

IBM Power8 end of service: What are my options?

3 min read - IBM Power8® generation of IBM Power Systems was introduced ten years ago and it is now time to retire that generation. The end-of-service (EoS) support for the entire IBM Power8 server line is scheduled for this year, commencing in March 2024 and concluding in October 2024. EoS dates vary by model: 31 March 2024: maintenance expires for Power Systems S812LC, S822, S822L, 822LC, 824 and 824L. 31 May 2024: maintenance expires for Power Systems S812L, S814 and 822LC. 31 October…

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