On Mon, 2018-12-03 at 18:41 +, Scott Rankin wrote:
> Upon further analysis, this is - unsurprisingly - taking place when we have
> multiple prefixed search terms in a ts_query going against a tsvector index.
>
> We have roughly 30 million rows in the table, and the search column is
> basical
Upon further analysis, this is - unsurprisingly - taking place when we have
multiple prefixed search terms in a ts_query going against a tsvector index.
We have roughly 30 million rows in the table, and the search column is
basically a concatenation of a location's name (think "Walmart #123456")
