4 ms·
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 https://githu
by grncdr 5y ago
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 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.
- craigkerstiens 5y agoActually 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 https://www.crunchybridge.com).
- grncdr 5y agoCool 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.
- craigkerstiens 5y agoDo 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.
- james_in_the_uk 5y agoDublin usually works well from a regulatory perspective.
- jhoechtl 5y agoThey are the 52 state of america. The 51 was already taken. https://en.wikipedia.org/wiki/51st_State_(song) https://en.wikipedia.org/wiki/51st_State_(song)
- thom 5y agoTop X queries should be optimised with gist indexes.
- grncdr 5y agoAh sounds like I need to update myself on this. I don’t recall what the other trade-offs vs GIN indexes are.