DefGuard / DefGuard/defguard

Add index on search terms for event log table

Open
#1,171 0 comments 0 reactions 1 assignee Claimed by @wojcik91 View on GitHub
Dominant language
Rust
Stars
2.8k
Forks
115
Avg merge
1d 4h
Merged PRs (30d)
51

Description

It is possible to add an expression index in Postgres: https://www.postgresql.org/docs/current/indexes-expressional.html

Since we support a simple text search on multiple columns by combining their content we could add a dedicated index for the expression we are using.
Unfortunately this requires some additional work because the `text` function we use for casting JSON metadata is locale-dependent which makes the expression not immutable.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.