Re:Postgres text search: balancing query time and relevancy
by throwaway-kg8d5 on Friday October 15, 2021 @04:28AM
(#28875598)
> you can approximate that by doing a LIMIT on unsorted results in a subselect
If you still have time left over, you can increase this LIMIT and run the query again (c.f. "iterative deepening") to get something like the desired time-limited query behaviour
If you still have time left over, you can increase this LIMIT and run the query again (c.f. "iterative deepening") to get something like the desired time-limited query behaviour