Skip to content

Instantly share code, notes, and snippets.

@tamalsaha

tamalsaha/kubedb-pg-16g.yaml

Created December 11, 2024 07:30
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tamalsaha/cfdf61b3fd5800155442b3140f5c2601 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tamalsaha/cfdf61b3fd5800155442b3140f5c2601 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. tamalsaha created this gist Dec 11, 2024.
    39 changes: 39 additions & 0 deletions kubedb-pg-16g.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,39 @@
    apiVersion: charts.x-helm.dev/v1alpha1
    kind: ClusterChartPreset
    metadata:
    labels:
    charts.x-helm.dev/is-default-preset: kubedb-pg-16g
    name: kubedb-pg-16g
    spec:
    values:
    spec:
    persistence:
    size: 20Gi
    podResources:
    machine: "db.t.xlarge"
    configuration: |
    # DB Version: 16
    # OS Type: linux
    # DB Type: web
    # Total Memory (RAM): 16 GB
    # CPUs num: 4
    # Connections num: 200
    # Data Storage: ssd
    max_connections = 200
    shared_buffers = 4GB
    effective_cache_size = 12GB
    maintenance_work_mem = 1GB
    checkpoint_completion_target = 0.9
    wal_buffers = 16MB
    default_statistics_target = 100
    random_page_cost = 1.1
    effective_io_concurrency = 200
    work_mem = 10485kB
    huge_pages = off
    min_wal_size = 1GB
    max_wal_size = 4GB
    max_worker_processes = 4
    max_parallel_workers_per_gather = 2
    max_parallel_workers = 4
    max_parallel_maintenance_workers = 2
    35 changes: 35 additions & 0 deletions kubedb-pg-8g.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,35 @@
    apiVersion: charts.x-helm.dev/v1alpha1
    kind: ClusterChartPreset
    metadata:
    labels:
    charts.x-helm.dev/is-default-preset: kubedb-pg-8g
    name: kubedb-pg-8g
    spec:
    values:
    spec:
    persistence:
    size: 20Gi
    podResources:
    machine: "db.t.large"
    configuration: |
    # DB Version: 16
    # OS Type: linux
    # DB Type: web
    # Total Memory (RAM): 8 GB
    # CPUs num: 2
    # Connections num: 100
    # Data Storage: ssd
    max_connections = 100
    shared_buffers = 2GB
    effective_cache_size = 6GB
    maintenance_work_mem = 512MB
    checkpoint_completion_target = 0.9
    wal_buffers = 16MB
    default_statistics_target = 100
    random_page_cost = 1.1
    effective_io_concurrency = 200
    work_mem = 10485kB
    huge_pages = off
    min_wal_size = 1GB
    max_wal_size = 4GB
    254 changes: 254 additions & 0 deletions pg-resourceeditor.yaml
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,254 @@
    apiVersion: ui.k8s.appscode.com/v1alpha1
    kind: ResourceEditor
    metadata:
    creationTimestamp: null
    labels:
    k8s.io/group: kubedb.com
    k8s.io/kind: Postgres
    k8s.io/resource: postgreses
    k8s.io/version: v1
    name: kubedb.com-v1-postgreses
    spec:
    icons:
    - src: https://cdn.appscode.com/k8s/icons/kubedb.com/postgreses.svg
    type: image/svg+xml
    - src: https://cdn.appscode.com/k8s/icons/kubedb.com/postgreses.png
    type: image/png
    resource:
    group: kubedb.com
    kind: Postgres
    name: postgreses
    scope: Namespaced
    version: v1
    ui:
    actions:
    - items:
    - editor:
    name: kubedbcom-postgres-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-edit
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/configure-backup.svg
    type: image/svg+xml
    name: Configure Backup
    operationId: edit-self-backupconfiguration
    - editor:
    name: corekubestashcom-backupsession-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/instant-backup.svg
    type: image/svg+xml
    name: Instant Backup
    operationId: create-instant-backup
    - editor:
    name: corekubestashcom-restoresession-editor-options
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/restore.svg
    type: image/svg+xml
    name: Restore
    operationId: create-restoresession
    name: Backups
    - items:
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/version.svg
    type: image/svg+xml
    name: Update Version
    operationId: create-opsrequest-upgrade
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/restart.svg
    type: image/svg+xml
    name: Restart
    operationId: create-opsrequest-restart
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/reconfigure.svg
    type: image/svg+xml
    name: Reconfigure
    operationId: create-opsrequest-reconfigure
    name: Operations
    - items:
    - disabledTemplate: |
    {{ not (hasKey .spec "standbyMode") }}
    editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/horizontal_scale.svg
    type: image/svg+xml
    name: Horizontal Scale
    operationId: create-opsrequest-horizontalscaling
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/vertical_scale.svg
    type: image/svg+xml
    name: Vertical Scale
    operationId: create-opsrequest-verticalscaling
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/expand.svg
    type: image/svg+xml
    name: Expand Volume
    operationId: create-opsrequest-volumeexpansion
    name: Scaling
    - items:
    - editor:
    name: kubedbcom-postgres-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    flow: standalone-edit
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/compute.svg
    type: image/svg+xml
    name: Compute
    operationId: edit-self-compute-autoscaler
    - editor:
    name: kubedbcom-postgres-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    flow: standalone-edit
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/storage.svg
    type: image/svg+xml
    name: Storage
    operationId: edit-self-storage-autoscaler
    name: Autoscaling
    - items:
    - editor:
    name: opskubedbcom-postgresopsrequest-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-create
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/configure.svg
    type: image/svg+xml
    name: TLS Configure
    operationId: create-opsrequest-reconfiguretls
    - editor:
    name: kubedbcom-postgres-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: false
    flow: standalone-edit
    icons:
    - src: https://cdn.appscode.com/k8s/icons/action-icons/monitor.svg
    type: image/svg+xml
    name: Monitoring
    operationId: edit-self-monitoring
    name: Security & Monitoring
    editor:
    name: kubedbcom-postgres-editor
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    enforceQuota: true
    options:
    name: kubedbcom-postgres-editor-options
    sourceRef:
    apiGroup: source.toolkit.fluxcd.io
    kind: HelmRepository
    name: appscode-charts-oci
    version: v0.11.0
    variants:
    - name: pg-8g
    title: PostgreSQL 8GB
    selector:
    matchExpressions:
    - key: charts.x-helm.dev/is-default-preset
    operator: In
    values:
    - "true"
    - kubedb
    - kubedb-pg-8g
    - name: pg-16g
    title: PostgreSQL 16GB
    selector:
    matchExpressions:
    - key: charts.x-helm.dev/is-default-preset
    operator: In
    values:
    - "true"
    - kubedb
    - kubedb-pg-16g