Greenstand / Greenstand/treetracker-testing

Test the difference of performance between PostgreSQL varchar and uuid

Open
#1 0 comments 0 reactions 0 assignees View on GitHub
good first issue
Dominant language
No language data
Stars
1
Forks
2
PR merge metrics
No merged PRs in 30d

Description

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

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.