tobi
tobi
Ah right thanks, I'll see if I can put something up there for now then, so you can interact with instances running GtS main that are already sending messages with...
Much appreciated :) I'll fiddle with gotosocial.org and get back to you when the document is up.
@zotanmew @puckipedia The document is now served at https://gotosocial.org/ns :)
Thanks :) I'll try to get around to updating our go-fed fork to use that context, when time permits.
> Which Pinafore doesn’t even display. Unfortunately it's part of the Mastodon API so we don't really have much of a choice, since some clients do display it... Personally I'd...
Ah thanks for catching it again! I still feel like 1GiB should be more than enough, so I reckon we've gotta do some creative thinking about performance improvements for this...
It's berserk to me that postgres struggles so hard with this when sqlite handles it no problem. Very frustrating. As stated above, we can't use the estimate function because we...
Multiple processes can open an sqlite db file at the same time, and indeed this is what we do in GtS with WAL mode and multiple open connections. https://www.sqlite.org/faq.html#q5 But...
Mmm, okay that all sounds fine indeed. That's similar to the gts.superseriousbusiness.org setup, which also has a bunch of stuff running on it (including other db clients). And the drive...
Ah it's cool that the query times are reduced even on HDDs with the ANALYZE :) What we found with SQLite recently is that unless you do regular ANALYZEs, then...