Skip to content

Staging environment differs from the production environment

The staging environment is different from production in many aspects. Using this issue to gather the differences and any issues related to this.

Differences

Staging Production
Database instance type n1-standard-8 (8 vCPUs, 30 GB memory) n1-highmem-96 (96 vCPUs, 624 GB memory)
Database cluster size (instance count) 6 12
Database size 0.5 TB 4 TB
Traffic nearly none production traffic
Statement timeout 10s 15s

Issues

  • Query times are perceived to be slower in staging than in production (observation by @stanhu from performance bar comparison)
  • Issue with post-deploy migration: Query times out in staging, not in production !15137 (merged)
Edited by Andreas Brandl