After receiving an interesting mail from Veeam forum digest, I thought it's a good idea to share the info. It's about using an external PG Db optimizer that allows you to optimize your PG servers. In the case of Veeam, the user was able to solve a ticket by optimizing their PostgreSQL server.
Note that those settings, you should take them with a grain of salt. For example, I would always copy my conf file so I can restore back my original settings. I'd be cautions, that's all.
Quote:
At postgres conf we used an external pgoptimizer https://pgtune.leopard.in.ua/ that helped us to improve the PGSQL.
So I went ahead to that page and there you can enter the values of your server (number of CPU, how many Gb of RAM it uses etc), then generate a config file.
You can then copy configuration to the clipboard, add/modify this settings in the postgresql.conf and restart database.
The second tab called Alter system writes the given parameter setting to the posgressql.auto.conf file which is read in additon to posgresql.conf.
Quote from the page:
PGTune calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration. It isn't a silver bullet for the optimization settings of PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of queries. An optimal configuration of the database can only be made given all these parameters are taken into account.
The page link is here
More posts from ESX Virtualization:
- VMware vSphere 8.0 U2 Released – ESXi 8.0 U2 and VCSA 8.0 U2 How to update
- What’s the purpose of those 17 virtual hard disks within VMware vCenter Server Appliance (VCSA) 8.0?
- VMware vSphere 8 Update 2 New Upgrade Process for vCenter Server details
- VMware vSAN 8 Update 2 with many enhancements announced during VMware Explore
- What’s New in VMware Virtual Hardware v21 and vSphere 8 Update 2?
- Homelab v 8.0
- vSphere 8.0 Page
- Veeam Bare Metal Recovery Without using USB Stick (TIP)
- ESXi 7.x to 8.x upgrade scenarios
- A really FREE VPN that doesn’t suck
- Patch your ESXi 7.x again
- VMware vCenter Server 7.03 U3g – Download and patch
- Upgrade VMware ESXi to 7.0 U3 via command line
- VMware vCenter Server 7.0 U3e released – another maintenance release fixing vSphere with Tanzu
- What is The Difference between VMware vSphere, ESXi and vCenter
- How to Configure VMware High Availability (HA) Cluster
Stay tuned through RSS, and social media channels (Twitter, FB, YouTube)
Leave a Reply