Does PostgreSQL 9.6 have direct storage facilities like Oracle or Microsoft SQL Server to deal with:
- read-only storage?
- compressed storage?
- limited storage?
- planned capacity storage?
- verifying physical data integrity? (eg : values for datatypes)
- verifying logical data integrity? (constraints)
Thanks
re 1) no
re 2) Postgres compresses data automatically, but can also store its database files on a file system that compresses (e.g. btrf, zfs, NTFS)
re 5) To verify physical integrety, you can turn on checksums on data pages during initdb. Not sure what you mean with "values for datatypes" but Postgres won't let you store invalid values for a datatype (e.g. February 31st in a
date
column).re 6) that's what constraints are for
no idea what 3 and 4 are supposed to mean.