Hi all,
I'm building a test database for our data warehouse,and I'm trying to build a trigram index on one of the tables with a 4000 character varchar field, Yes, I want to change this table at some point to make that attribute a text field, along with some other structural changes. but that's in the future. This particular table reports to be approximately 420 Gb. My question is fairly simple, this index has been building since Tuesday morning @ 9:52AM EST - nearly 48 hours. Does this sound like a normal build time? The command I used is:CREATE INDEX CONCURRENTLY test_schema_notes_trigram_idx on test_schema.notes USING gin (notes gin_trgm_ops);
--