Re: Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it

2023-09-24 Thread Jeff Janes
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

Re: Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it

2023-05-25 Thread Tomas Vondra
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,

Question regarding specifics of GIN and pg_trgm performance and potential use of show_trgm to improve it

2023-05-24 Thread Pavel Horal
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,