Code Monkey home page Code Monkey logo

Comments (4)

gbartolini avatar gbartolini commented on May 12, 2024 1

Example of proposal of configuration for tablespace definition:

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: cluster-with-tablespaces
spec:
  instances: 3

  storage:
    size: 10Gi

  walStorage:
    size: 2Gi

  tablespaces:
    angus:
       temporary: true
       storage:
          size: 4Gi
    malcolm:
       storage:
          size: 2Gi
    bon:
       storage:
          size: 2Gi

from cloudnative-pg.

adminnz avatar adminnz commented on May 12, 2024 1

Maybe allowing more direct control over the volumes in the Cluster CRD?

You could declare the volumes & their mounts (effectively using the existing k8s PersistentVolumeSpec).
Then reference them with tablespaces.

Something like:

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: cluster-with-tablespaces
spec:
  instances: 3

  volumes:
  - name: data_slow 
    storageClassName: standard
    capacity: 
       storage: 10Gi
    accessModes:
      - ReadWriteOnce
    hostPath:
      path: /mnt/data_slow
  - name: data_fast
    storageClassName: premium
    capacity: 
       storage: 5Gi
    accessModes:
      - ReadWriteOnce
    hostPath:
      path: /mnt/data_fast
 
  tablespaces:
    tblspace_fast:
       volume: data_fast
    tblspace_slow:
       volume: data_slow

from cloudnative-pg.

d3btech avatar d3btech commented on May 12, 2024 1

@gbartolini Good problem statement. I just posted the same on Discussions forum. It is such important for large databases. Any update?

from cloudnative-pg.

jsilvela avatar jsilvela commented on May 12, 2024 1

@gbartolini I think we can close this? Since development is under way and the spec is done...

from cloudnative-pg.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.