PostgreSQL Tuning further for this use case - Reduce Page Size from 8KB to 4KB, great for write heavy operations and indexed reads. Needs to compile source wit

PostgreSQL Tuning further for this use case - Reduce Page Size from 8KB to 4KB, great for write heavy operations and indexed reads. Needs to compile source with those flags, cant configure once installation is done. - Increase Buffer cache - Table partitioning for UNLOGGED Table which the author is using - At connection session level, lower the transaction level from SERIALIZABLE - The new UUID7 in PG 18 as a key might also help as primary indexed KEY type as it also supports range queries on timestamp