Comments (4)
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.
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.
@gbartolini Good problem statement. I just posted the same on Discussions forum. It is such important for large databases. Any update?
from cloudnative-pg.
@gbartolini I think we can close this? Since development is under way and the spec is done...
from cloudnative-pg.
Related Issues (20)
- setup creadentials for preflight check in ci workflow
- [Bug]: Logger PGAudit not working, postgres logger is used instead HOT 2
- [Bug]: Kubectl Plugin displays default Operator Image version, when using ImageCatalog in Cluster CR
- [Bug]: CNPG 1.23 - cannot create Cluster auxiliary objects: expected pointer, but got invalid HOT 2
- [Bug]: Replica starts recovery from backup that is outside of retention period.
- [Bug]: Node restarts may render cluster broken HOT 1
- [Docs]: development env setup instructions don't support Apple Silicon
- [Docs]: Release notes for 1.23.1
- [Feature]: Add Container Lifecycle Hooks (PostStart,PreStop) for containers in the Cluster CRD
- [Bug]: Recovery from WAL fails when tablespace was added HOT 1
- [Bug]: New replica searches for WAL archive that doesn't exist
- [Feature]: ScheduledBackup resource should be able to backup using plugin method
- [Bug]: Operator restarting due to DetectAvailableArchitectures()
- [Bug]: Operator test should rely on Deployments not counting pods
- [Docs]: guide on production readiness for CNPG HOT 2
- [Bug]: Do not start the psql or minio container for tests if not needed
- [Bug]: The instance manager is not able to unfence PG after a previous unfence operation failed
- [Feature]: Specify addtional labels for PodMonitor
- [Bug]: Missing log line if only the private key is changed in a TLS secret
- [Feature]: Is there any way we can have sidecar container with PG container in same pod ?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cloudnative-pg.