Timeline for Best index for similarity function
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 2 at 2:48 | comment | added | Erwin Brandstetter | @Tallboy: Sure, any B-tree Index with leading timestamp column. | |
| Jan 2 at 2:11 | comment | added | Tallboy | this is a great answer - is there an index you might recommend if I'm not doing a comparison with a threshhold? Im literally showing the actual similarity to the user as a %, so they know if some content they created exists with in the last 5 days. In this sense, i need to do a cross join similarity score on ALL x ALL from last 5 days. from what i gather no index well really help here.. but is there anything else that might speed this process up? | |
| Aug 1, 2023 at 18:05 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
link
|
| May 6, 2021 at 21:41 | history | edited | Erwin Brandstetter | CC BY-SA 4.0 |
suggest pg_trgm.similarity_threshold instead of the deprecated set_limit(); reformat, denoise, links
|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Jun 16, 2015 at 0:36 | vote | accept | bl0b | ||
| Jun 16, 2015 at 0:15 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
typo
|
| Jun 13, 2015 at 16:39 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
clarify some more
|
| Jun 13, 2015 at 10:22 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
explain <->
|
| Jun 13, 2015 at 1:40 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
add a lot more
|
| Jun 11, 2015 at 18:44 | history | answered | Erwin Brandstetter | CC BY-SA 3.0 |