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

Test the difference of performance between PostgreSQL varchar and uuid #1

Open
dadiorchen opened this issue May 5, 2023 · 0 comments
Labels
good first issue Good for newcomers

Comments

@dadiorchen
Copy link
Contributor

Now we are using varchar for trees.uuid, and use wallet.toekn.capture_id as a reference of trees.uuid, but it is in uuid type, so we need join data by: trees.uuid::text = token.capture_id::text to cast type and compare, we need find out the performance of this operation and potential optimization.

image

Please contact me for the db resources for testing

@dadiorchen dadiorchen added the good first issue Good for newcomers label May 5, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

1 participant