/slow-semi-accurate-full-text-search.sql
Last active Aug 19, 2018
Slow & Semi-Accurate Full-Text Search in PostgreSQL
| SELECT story_url, count(*) as count, max(updated_at) as updated_at | |
| FROM "comments" | |
| WHERE ("comments"."updated_at" BETWEEN '2018-01-01' AND '2018-07-06') | |
| AND (comment_text LIKE '%google%') | |
| GROUP BY story_url, story_title HAVING (count(*) > '7') | |
| ORDER BY count DESC LIMIT 15; | |
| Planning time: 0.472 ms | |
| Execution time: 42839.333 ms | |
| /* WHERE ("comments"."updated_at" BETWEEN '2018-07-01' AND '2018-07-06') */ | |
| https://medium.com/@serverpunch/why-you-should-not-use-google-cloud-75ea2aec00de | 34 | | |
| 2018-07-01 01:39:39 | 2018-07-01 12:30:09 | |
| https://github.com/harababurel/gcsf | 9 | 2018-07-01 02:35:09 | 2018-07-01 17:30:11 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment