Search

Nikolay and Michael have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. They discuss what comes in Postgres core, what is possible via extensions, and some thoughts on performance vs implementation complexity vs user experience.

 
Here are some links to things they mentioned:

• Simon Riggs https://www.linkedin.com/feed/update/urn:li:activity:7178702287740022784/
• Companion databases episode https://postgres.fm/episodes/companion-databases
• pgvector episode https://postgres.fm/episodes/pgvector
• Full Text Search https://www.postgresql.org/docs/current/textsearch.html
• Semantic search https://en.wikipedia.org/wiki/Semantic_search
• Faceted search https://en.wikipedia.org/wiki/Faceted_search
• Faceting large result sets in PostgreSQL https://www.cybertec-postgresql.com/en/faceting-large-result-sets/
• RUM …

databases postgres postgresql sql technology