Fix rich indexer `partial` query by args performance issue - Githubissues

nervosnetwork / ckb

The Nervos CKB is a public permissionless blockchain, and the layer 1 of Nervos network.

https://www.nervos.org

MIT License

1.14k stars 224 forks source link

Fix rich indexer `partial` query by args performance issue #4484

Closed EthanYuan closed 4 weeks ago

EthanYuan commented 1 month ago

What problem does this PR solve?

Problem Summary:

https://github.com/Magickbase/infra/issues/85#issuecomment-2161984108

What is changed and how it works?

What's Changed:

use LIKEinstead of position func for PostgreSQL to avoid performance issues
The README has been updated to emphasize the software and hardware requirements.

Check List

Tests

Unit test
Manual test

Release note

Title Only: Include only the PR title in the release note.