News for hackers. Stuff that matters.

A comment on Postgres Full-Text Search: A search engine in a database. Parent comment

Re:Postgres Full-Text Search: A search engine in a database by grncdr on Tuesday July 27, 2021 @12:01PM (#27973991)
My experience has been that sorting by relevance ranking is quite expensive. I looked into this a bit and found https://github.com/postgrespro/rum (and some earlier slide decks about it) that explains why the GIN index type can't support searching and ranking itself (meaning you need to do heap scans for ranking). This is especially problematic if your users routinely do searches that match a lot of documents and you only want to show the top X results.

Edit: if any of the Crunchy Data people are reading this: support for RUM indexes would be super cool to have in your managed service.

[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by craigkerstiens on Tuesday July 27, 2021 @12:52PM (#27974621)
Actually thats a great suggestion. We need to take a deeper look at the code itself and ability to support the extension, but we'll definitely take and evaluate it at some of our upcoming roadmap planning for Crunchy Bridge (https://www.crunchybridge.com).
[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by grncdr on Tuesday July 27, 2021 @04:55PM (#27977529)
Cool cool

If I could have your other ear for a moment: support for any EU-based cloud provider would be super nice. Ever since the Privacy Shield fig leaf was removed, questions about whether we store any data under US jurisdiction have become a lot more frequent.

[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by craigkerstiens on Tuesday July 27, 2021 @05:03PM (#27977640)
Do you have a preferred one?

We're currently on the big 3 US ones, in process of working on our 4th provider, our goal is very much to deliver the best Postgres experience whether on bare metal/on-premise or in the cloud, self hosted or fully managed.

Edit: Always feel free to reach out directly, I'm always happy to spend time with anyone that has questions and usually pretty easy to track me down.

[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by james_in_the_uk on Tuesday July 27, 2021 @07:34PM (#27978875)
Dublin usually works well from a regulatory perspective.
[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by jhoechtl on Wednesday July 28, 2021 @07:53AM (#27982738)
They are the 52 state of america. The 51 was already taken.

https://en.wikipedia.org/wiki/51st_State_(song)

[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by thom on Tuesday July 27, 2021 @02:47PM (#27976020)
Top X queries should be optimised with gist indexes.
[ Parent | on HN ]
Re:Postgres Full-Text Search: A search engine in a database by grncdr on Tuesday July 27, 2021 @04:57PM (#27977572)
Ah sounds like I need to update myself on this. I don’t recall what the other trade-offs vs GIN indexes are.
[ Parent | on HN ]