Benchmark: Snowflake vs UUIDv4

This benchmark compares the performance of Snowflake and UUID. It was built using Go, Docker, SQLx, and PostgreSQL.

The graphs below were generated using Python3.

Understanding the benchmark

Go is the main programming language used for the benchmark. Each ID type (Snowflake or UUID) has its own .go file for running the benchmark separately. The benchmarked operations include:

• SELECTION (SELECT * FROM)


• ORDERED SELECTION (SELECT ORDER BY)


• ID GENERATION


• ID GENERATION + INSERT


• ID SEARCH (SELECT WHERE)


• UPDATE

For each …

benchmark database datascience docker file generated go graphs language performance postgresql programming programming language python3 running snowflake type understanding