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

Metadata needs to be indexed #178

Open
stakach opened this issue Jun 21, 2022 · 0 comments
Open

Metadata needs to be indexed #178

stakach opened this issue Jun 21, 2022 · 0 comments
Assignees
Labels
focus: backend Focus on Back End Development product: placeos Issue relates to PlaceOS Product squad: core PlaceOS Core Development type: bug something isn't working

Comments

@stakach
Copy link
Member

stakach commented Jun 21, 2022

currently a simple metadata search locks up the database due to high CPU when there are 1000's of records (client with 24k records sees a 5minute denial of service)

Thinking we move metadata over to postgresql soon #165
possibly as part of staff api which also has metadata and some change hooks into rethinkdb, reverting the metadata field in rethink back to text

Then search operations can occur on staff API against a postgresql GIN index
https://cgi.cse.unsw.edu.au/~cs9315/20T1/postgresql/documentation/functions-json.html
https://medium.com/hackernoon/how-to-query-jsonb-beginner-sheet-cheat-4da3aa5082a3

@stakach stakach added squad: core PlaceOS Core Development product: placeos Issue relates to PlaceOS Product priority: critical focus: backend Focus on Back End Development type: bug something isn't working labels Jun 21, 2022
@jeremyw24 jeremyw24 reopened this Jun 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
focus: backend Focus on Back End Development product: placeos Issue relates to PlaceOS Product squad: core PlaceOS Core Development type: bug something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants