Keep it simple. Use integer IDs take advantage of the performance benefits of integer keys internally, and opaque, non-guessable identifiers externally.
How to use the pg_cron extension to schedule recurring jobs, partition cleanup, and materialized view refreshes directly inside PostgreSQL.