https://github.com/tvondra/sequential_uuids/
sequential_uuids implements two UUID generators with sequential patterns, which helps to reduce random I/O patterns associated with regular entirely-random UUID.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example sequential_uuids for PostgreSQL 17 is named as sequential_uuids_17. Similarly sequential_uuids for PostgreSQL 15 is named as sequential_uuids_15.
sequential_uuids provides the following subpackages:
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install sequential_uuids_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 sequential_uuids;
| 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 |