PostgreSQL Optimization
Best practices to scale your PostgreSQL investment
Our experts will help you optimize your databases and arm you with the knowledge to move forward successfully
PostgreSQL Optimization Services
Performance Tuning →
We’ll ensure your servers are tuned to your use cases for best performance
Monitoring: Best Practices →
We’ll teach you how to monitor and alert so you always know how your PostgreSQL investment is doing
Backup: Best Practices →
Never lose data again. Plan your backup strategy with best practices from PostgreSQL experts.
Performance Tuning
After reviewing your infrastructure and determining your baseline with automated tools, we’ll guide you to make adjustments to improve your database performance, taking into consideration your most common transactions (read-only vs write). After adjustments are made, we’ll show you how much the tuning improved performance. Includes:
- Review infrastructure & platform
- Measure application performance to determine the performance baseline using an app test harness, highlighting bottlenecks
-
Recommend database tuning methods (from application specifications to configuration)
- Transaction size (fsync vs bandwidth)
- Read vs. write frequency
- Query complexity (OLTP vs OLAP)
- From connections/query complexity to memory settings
-
Review the implementation and make recommendations for
- Partitioning vs no partitioning
- Read scalability
- Connection pooling
- Measure performance after recommended changes to show the impact of the changes
Monitoring: Best Practices
Almost nothing is worse than having an end user tell you that your service is having trouble processing transactions. Let us help you avoid that so you always know the health and status of your databases. Includes:
- Reviewing your monitoring stack
- Recommending best monitoring solutions
- Creating customized plans for alerting and notification
- Building out best practices for incorporating PostgreSQL into your infrastructure
-
Example stacks
- Stack 1: Prometheus, Grafana, PagerDuty, Elastic Stack
- Stack 2: Dynatrace, Splunk, ServiceNow
Backup: Best Practices
We’ll show you different backup strategies, including the pros and cons of each option, and make recommendations based on your needs. After reviewing your stack, we’ll give you customized guidance on how to set up and configure backups so that you never lose data. Includes:
- Review of your stack
- Review of backup options and recommendations
- Build out best practices for backing up data
-
Example stacks
-
Stack 1
- Stage 1: BART on separate server
- Stage 2: A backup tool such as CommVault or NetVault
-
Stack 2
- Stage 1: pghoard / wal-g
- Stage 2: Buckets
-
Stack 3
- Stage 1: BART to NFS
- Stage 2: Anything to backup NFS storage
- Stack 4: Use default backup integration from CommVault or Netvault
- Stack 5: Snapshotting and archiving
-
Stack 1