Mark/nodedesk
1
0
Fork 0
Code Issues 1 Pull requests Projects Releases Packages Wiki Activity Actions

ND-007: Replace primary search path with Postgres FTS #11

New issue
Closed
opened 2026-03-03 23:20:52 +00:00 by Mark · 0 comments
Mark commented 2026-03-03 23:20:52 +00:00
Owner
Copy link

Metadata

  • Type: ticket
  • Priority: high
  • Estimate: XL
  • Area: search

Parent epic: #3

Dependencies

ND-002

Scope

  • Add migration for tsvector search vectors and indexes
  • Update server query path from ILIKE fallback to FTS primary
  • Keep safe fallback behavior where necessary
  • Capture before/after search performance for representative queries

Acceptance Criteria

  • Search queries use FTS indexes on primary path
  • Relevance and response times improve on benchmark set
  • Migration is reversible and documented
## Metadata - Type: ticket - Priority: high - Estimate: XL - Area: search Parent epic: #3 ## Dependencies ND-002 ## Scope - Add migration for `tsvector` search vectors and indexes - Update server query path from ILIKE fallback to FTS primary - Keep safe fallback behavior where necessary - Capture before/after search performance for representative queries ## Acceptance Criteria - Search queries use FTS indexes on primary path - Relevance and response times improve on benchmark set - Migration is reversible and documented
Mark closed this issue 2026-07-16 15:30:10 +00:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
blocked:gate-fetch

   
blocked:gate-implement

   
blocked:needs-attention

   
blocked:needs-decision

   
blocked:needs-human

   
blocked:needs-local-checkout

   
blocked:no-changes

   
bug

Bug report

  
feature-request

   
in-progress

   
needs-decompose

Ready to be decomposed into sub-issues

  
needs-triage

   
ops-task

   
quickfix

   
security/high

High severity security issue

  
security/low

Low severity security issue

  
security/medium

Medium severity security issue

  
triage-approved
No labels
blocked:gate-fetch
blocked:gate-implement
blocked:needs-attention
blocked:needs-decision
blocked:needs-human
blocked:needs-local-checkout
blocked:no-changes
bug
feature-request
in-progress
needs-decompose
needs-triage
ops-task
quickfix
security/high
security/low
security/medium
triage-approved
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
Mark/nodedesk#11
No description provided.