Re:Improving Postgres text search speed
by rubyist5eva on Saturday August 13, 2022 @08:39AM
(#32449333)
I’ve seen it happen when people forget to index the foreign key columns, it also may be faster on one to many joins if you need to use DISTINCT to remove duplicate rows (instead of joining on a specific subquery that eliminates the duplication implicitly).
[ Parent
| on HN ]
There are no comments on this comment yet.