News for hackers. Stuff that matters.

A comment on Partitioning Postgres tables by timestamp based UUIDs.

Re:Partitioning Postgres tables by timestamp based UUIDs by canadiantim on Friday January 12, 2024 @08:55AM (#38967940)
Nice writeup, very helpful!

I wonder at what point it makes more sense to adopt UUID v7 instead of ULID, but I guess that's a relatively irrelevant point.

[ Parent | on HN ]
Re:Partitioning Postgres tables by timestamp based UUIDs by eddd-ddde on Friday January 12, 2024 @10:18AM (#38969035)
I actually did a partitioned table over uuid v7. It works nicely, but the extension requieres manual installation which is sort of a pain.
[ Parent | on HN ]
Re:Partitioning Postgres tables by timestamp based UUIDs by kjmph on Friday January 12, 2024 @10:37AM (#38969298)
While it may not work for all use cases, there is a Postgres PL/pgSQL function that is easy to install. It is being kept here for now:

https://gist.github.com/kjmph/5bd772b2c2df145aa645b837da7eca...

[ Parent | on HN ]
Re:Partitioning Postgres tables by timestamp based UUIDs by gmokki on Friday January 12, 2024 @05:40PM (#38975151)
Its coming as built-in function: https://commitfest.postgresql.org/43/4388/ hopefully it gets merged before the next release.
[ Parent | on HN ]