search

fboulnois / pg_uuidv7

A tiny Postgres extension to create version 7 UUIDs
Mozilla Public License 2.0
270 stars 23 forks source link

PL/pgSQL Version #5

Closed shellscape closed 1 year ago

shellscape commented 1 year ago

Hey there. Thanks for creating this extension! Was curious if it was either performant or possible to create a version of this using PL/pgSQL so that it can be used with AWS RDS, Supabase, etc (cloud postgres) and pg_tle.

fboulnois commented 1 year ago

There's a pure SQL version available here but it's about 20% slower than this extension: https://gist.github.com/kjmph/5bd772b2c2df145aa645b837da7eca74

shellscape commented 1 year ago

Good to know, thanks. Sadly we're limited with most Postgres cloud instances

fboulnois commented 1 year ago

Closing since there's an existing PL/pgSQL solution.