On Wed, May 24, 2023 at 4:35 PM Pavel Horal
wrote:
I didn't see your email when first sent, and stumbled upon it while
searching for something else. But it still might be worthwhile commenting
even after all of this time.
>
>
*Is my understanding correct that this happens only because pg_trgm
On 5/24/23 22:28, Pavel Horal wrote:
> Hello PostgreSQL community,
>
> I am trying to improve performance of using similarity based queries on
> a large datasets and I would like to confirm my understanding of how GIN
> indexes work and how pg_trgm uses them.
>
> If I understand it correctly, usi
Hello PostgreSQL community,
I am trying to improve performance of using similarity based queries on a
large datasets and I would like to confirm my understanding of how GIN
indexes work and how pg_trgm uses them.
If I understand it correctly, using GIN index is always a two step process:
first, p