google/gke-compute-classes — assets/postgres-primary-compute-class.yaml

# EXAMPLE TEMPLATE - DO NOT DEPLOY
apiVersion: cloud.google.com/v1
kind: ComputeClass
metadata:
  name: postgres-primary
spec:
  # Primary Postgres node, zone-pinned for PV affinity. Reservation-first, On-Demand fallback, all-Gen-4 (Hyperdisk), no Spot.
  # DATA PVs: use the built-in `dynamic-rwo` StorageClass (GKE 1.35.3-gke.1290000+,
  # use-allowed-disk-topology: "true") — see assets/dynamic-rwo-storageclass.yaml. It makes
  # the Cluster Autoscaler scale up only disk-compatible nodes, so you can safely widen the
  # priorities[] below across machine families/generations without PV attach failures.
  # (bootDiskType below is the NODE boot disk, a separate concern from the data PV StorageClass.)
  nodePoolAutoCreation:
    enabled: true
  # NOTE: priorityDefaults.location omitted — it would conflict with the
  # Specific reservation on priority 1. Reservation zone scope lives in
  # reservations.specific[].zones; non-reservation priorities set
  # location.zones explicitly.
  priorityDefaults:
    nodeSystemConfig:
      linuxNodeConfig:
        sysctls:
          net.core.somaxconn: 1024
          vm.overcommit_memory: 2   # strict — prevents OOM-killer surprises on large queries
  priorities:
  # 1. Specific reservation — pre-paid, highest obtainability. C4D (AMD Turin)
  # offers top-tier price-performance for Postgres.
  - machineFamily: c4d  # IMPORTANT: Align machineFamily with your existing CUDs/Reservations
    minCores: 16
    minMemoryGb: 128 # High-memory profile (8GB/vCPU) recommended for primary DB
    spot: false
    reservations:
      affinity: Specific
      specific:
      - name: postgres-primary-reservation
        zones: ['us-central1-a']    # zonal scope lives here for the reservation entry
    storage:
      bootDiskType: hyperdisk-balanced
      bootDiskSize: 100

  # 2. On-Demand N4D (AMD Turin) fallback in same zone (PV affinity)
  - machineFamily: n4d  # IMPORTANT: Align machineFamily with your existing CUDs/Reservations
    minCores: 16
    minMemoryGb: 128
    spot: false
    location:
      zones: ['us-central1-a']
    storage:
      bootDiskType: hyperdisk-balanced
      bootDiskSize: 100

  # 3. C4 (Intel) fallback in same zone
  - machineFamily: c4  # IMPORTANT: Align machineFamily with your existing CUDs/Reservations
    minCores: 16
    minMemoryGb: 128
    spot: false
    location:
      zones: ['us-central1-a']
    storage:
      bootDiskType: hyperdisk-balanced
      bootDiskSize: 100