PostgreSQL storage options

403 Views Asked by At

Does PostgreSQL 9.6 have direct storage facilities like Oracle or Microsoft SQL Server to deal with:

  1. read-only storage?
  2. compressed storage?
  3. limited storage?
  4. planned capacity storage?
  5. verifying physical data integrity? (eg : values for datatypes)
  6. verifying logical data integrity? (constraints)

Thanks

1

There are 1 best solutions below

1
On

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.