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
awarded  Scholar
Jun
16
accepted Best index for similarity function
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
15
awarded  Supporter
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
awarded  Editor
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
11
revised Best index for similarity function
add more info about my tables
Jun
11
asked Best index for similarity function
May
28
awarded  Notable Question
May
15
asked change column type from string to numeric
Sep
23
awarded  Notable Question
Aug
12
awarded  Popular Question
Jul
23
awarded  Popular Question
Jun
28
awarded  Student
Jun
26
asked Best practices to secure mysql
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?"
Jun
24
asked Which database?
Jun
24
asked How to manage a huge database?