https://github.com/optiver/timestamp9/
timestamp9 is an efficient nanosecond precision timestamp type for PostgreSQL.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example timestamp9 for PostgreSQL 17 is named as timestamp9_17. Similarly timestamp9 for PostgreSQL 15 is named as timestamp9_15.
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install timestamp9_17 (or change the version as described above) |
Connect to the database that you want to create the extension as superuser and run:
CREATE EXTENSION timestamp9;
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | Fedora Linux | x86_64 | Available |