Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

update readme with benchmarks #3

Closed
basaran opened this issue Dec 22, 2020 · 0 comments
Closed

update readme with benchmarks #3

basaran opened this issue Dec 22, 2020 · 0 comments

Comments

@basaran
Copy link

basaran commented Dec 22, 2020

Hello,

In case you would like to update the README with some benchmarks, I compared them as follows.

--
-- AMD Ryzen 3400G, PG13, WSL Ubuntu 20.04
--

-- Generation

-- uuid-ossp 
-- "Execution Time: 2712.880 ms"
explain analyze SELECT uuid_generate_v4()
FROM generate_series(1, 499000) t(i);

-- "Execution Time: 5083.430 ms"
explain analyze SELECT ulid_create()
FROM generate_series(1, 499000) t(i);


-- "Execution Time: 5927.542 ms"
explain analyze SELECT generate_ulid()
FROM generate_series(1, 499000) t(i);

-- Inserts

-- INSERT 0 499000 uuid_generate_v4()
-- Query returned successfully in 6 secs 748 msec.

-- INSERT 0 499000  ulid_create()
-- Query returned successfully in 8 secs 529 msec.

-- INSERT 0 499000 generate_ulid()
-- Query returned successfully in 12 secs 99 msec.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant