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