-
• #177
Can you search Classifieds and exclude Closed threads? In fact, I'd question why this isn't the default behaviour - what's the point of closing threads otherwise?
-
• #178
Judging an acceptable price for a similar item?
-
• #180
Can you search Classifieds and exclude Closed threads? In fact, I'd question why this isn't the default behaviour - what's the point of closing threads otherwise?
This is a good request. I'm not sure one can search on thread status... let me check.
-
• #181
Nope... can't search on whether locked or not.
May add, if I can still build the frontend.
-
• #182
This is a good request.
-
• #183
Love you. Kisses!
-
• #184
What am I getting wrong?
I'm trying to find posts by me in a thread? If I go to the thread I want:
https://www.lfgss.com/conversations/144978/
and
enter
authorId: mineshouldn't that bring up everything i need?
-
• #186
ahhh i see where i was going wrong now. thanks!
-
• #187
I was reading this blog post recently: https://www.crunchydata.com/blog/postgres-full-text-search-a-search-engine-in-a-database
And it reminded me of this thread. I've never used Postgres' full text search capabilities and I was surprised how capable it is. The blog post also gives a reason to upgrade to PG >= 12
-
• #188
We are in the latest postgres 14.
And yeah the search is phenomenal.
The advantage of implementing search in the database are twofold:
- Permissions can be applied to the search at the time of search.
- No external service is needed for indexing.
We're using the search in a pretty advanced way, every single feature is being used from weighting, ranking, result snippets. It's pretty cool.
- Permissions can be applied to the search at the time of search.
-
• #189
Oh I didn't realise you were already using it - I could have just looked at the codebase :/
Congrats on the upgrade - did you see any improvement in response times and cpu usage, etc? -
• #190
Fractional benefits. This site was been optimised to hell about 8 years ago and hasn't needed to be revisited, and so the benefits from upgrades isn't significant.
That said, I am going to book a week off work to spend time working on the site and I want to add a lot more observability so that I can get a far better idea of slow queries and where the latency is. At the moment my hunch is that nearly all of the time is spent in the Django / Python rather than in the database or Go (API) layer. That hunch is driven by my local dev environment, where I have partially implemented the web layer in Go and the speedup is phenomenal and it's really revealing how bad the Python layer is in comparison.
The SQL layer... I have a slow query log and virtually nothing goes into it except for some very generic searches on the largest sites.
-
• #191
someone was asking about car hire in Montenegro recently but can i find it via search? Can I fuck...
-
• #192
https://www.lfgss.com/search/?q=Montenegro+sort:date
But can't see much there.https://www.lfgss.com/conversations/149770/?offset=50#comment16552577
That looks plausible... but doesn't contain the terms you wanted.Are you sure you remember how they phrased it?
-
• #193
ok thanks anyway.
-
• #194
Is it possible to have your search term to return results for any single of the words you write?
i.e:
House train bottleSo if the post had just the word train in it, it would come up in the results?
-
• #196
How do I search for my posts within a thread?
https://www.lfgss.com/search/?q= something or other +authorId% my authorId I guess?
-
• #197
Also would it be worth editing the first post to explain the first step in how to use the search/enter these fields?
-
• #199
Cheers I should have specified I meant in a particular thread
-
• #200
If you change the number after id that should give you the thread numer. this thread is 253146
https://www.lfgss.com/search/?q=Authorid%3A52172&type=conversation&type=comment&id=253146&sort=date
No, it kinda ignores attempts to do this and the PostgreSQL full text search engine just answers with what it believes is the most relevant ordering.