For those using the PG FTS patch to avoid installing ES, be aware of the default context in models/status.rb ( probably introduced recently ).
Your search_for should contain something like:
Status.where('tsv @@ plainto_tsquery(?)', pattern).order(updated_at: :desc).limit(limit)
to make sure no default scope are applied to that query.
FYI, mastodon v2.3.0rc2 instrumented.
Here's one report after 24hours:
oh and here is a few Full Text Search using only postgresql ( no ES patch ).
Depending on the cardinality of the word used as the search ( the more common the word is in toots, the longer the query time ). Worst case scenario represented on our 50M+ toots database by a query time of 17s.
Does someone lives in the US near a US Cellular shop ? I need one of their SIM cards for work and they won't sell to Cal :/ We'll of course pay for it and reimburse for the trouble, we just need a cheap phone and a prepaid sim card...
So for the record, if you take an old drone motor and tie it to your skateboard wheel, it works, just don't do that with the 4 wheels, it may be too much ;)
Eager to try upload files dedup...
Here's mastodon.host media files backup stats:
- Original size: 684.45 GB
- Compressed size: 677.22 GB
- Deduplicated size: 144.05 GB
I am tired of getting bike parts stolen while locked at the Bart station, so I am thinking of building a diy electric skate to commute and take it with me in the subway.
What do you use ? What did you found convenient ? What didn't worked ?
Me: Hey Postgres, can I do this?
Postres: Before I answer that, how are you? You look hungry have you eaten today?
Me: Uhm, well, I am a bit...
Postgres: *makes me a sandwich, plus me some juice* here you go...
Me: Oh wow, thanks, but I was wanted know...
Postgres: No, I can't do that, but you can try this, this or this. Do think any of those might work?
Me: Ah, ok. Yeah, that'll work. Actually that's probably better than was doing...
It has just occurred to me that, with my current skill with my guitar, I can safely say that I play homeopathic music.
I'm a homeopathic musician!
FYI any other a.weirder.earth residents: We've been hacked.
Woops, we are getting in that direction too ^^
( temporary setup to play with, do not settle there and expect stability, we will probably at some point migrate mastodon.host to pleroma when it gets a little bit more on par with mastodon features for the users and mods ).
So apparently, as long as your payload is < 6pounds, you don't need a license to send that thing to space... How heavy are little ham transceivers with an antenna ? ;) Weather balloon launch could be fun...
Ok yes I know, it's cold out there, need to isolate the electronics too...