Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 6
Newest
 Scholar
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Jun
16
comment Best index for similarity function
@ErwinBrandstetter Went from 30s to 6seconds. Great improvements! Thanks a lot!
Jun
16
comment Best index for similarity function
@ErwinBrandstetter thank you su much for the answer! Quick question: You say that GIN is faster and that I should install btree_gin. But then in the index creation you tell to run: CREATE INDEX lcas_trgm_gin_idx ON lcas USING gist (worksite_city, job_title gist_trgm_ops); Just a typo?
Jun
11
comment Best index for similarity function
I do have "index_lcas_job_title_trigram" gin (job_title gin_trgm_ops) I read somewhere that gin is faster than gist. Is that true?
Jun
11
comment Best index for similarity function
Thanks, I edited my post to include those informations/. And yes there is always an equality condition on worksite_city, worksite_state, year and/or status
Jun
24
comment How to manage a huge database?
Ok. My bad for the huge. Database isn't really my field. It's so far the biggest database i had to deal with. The others tables are pretty small. Only couple hundreds row and almost nothing inside. There is only this big table. Who is going to grow daily as well. Probably 20 000 row a day. My knowledge is actually pretty bad about DB, so sadly i don't understand this line: "Sadly, it all depends. Is it transactional or reporting / data warehouse?"