Re: insert and query performance on big string table with pg_trgm

2017-11-20 Thread Jeff Janes
On Mon, Nov 20, 2017 at 2:54 PM, Matthew Hall wrote: While I have not done exhaustive testing, from the tests I have done I've never found gist to be better than gin with trgm indexes. > > Here is the table: > >Unlogged table "public.huge_table" >Column

insert and query performance on big string table with pg_trgm

2017-11-20 Thread Matthew Hall
Hello PGSQL experts, I've used your great database pretty heavily for the last 4 years, and during that time it's helped me to solve an amazingly wide variety of data challenges. Last week, I finally ran into something weird enough I couldn't figure it out by myself. I'm using a self-compiled copy

Migration to PGLister - After

2017-11-20 Thread Stephen Frost
Greetings! This list has now been migrated to new mailing list software known as 'PGLister'. This migration will impact all users of this mailing list in one way or another. If you would like to unsubscribe from this mailing list, please click on 'Show Original' or 'Show Headers' in your client