Post B5TCukb1maP9AgQD20 by roguefoam@polymaths.social
 (DIR) More posts by roguefoam@polymaths.social
 (DIR) Post #B5TCukb1maP9AgQD20 by roguefoam@polymaths.social
       0 likes, 0 repeats
       
       Polymaths is at 123158 posts - I kinda want to watch closely and see if I can catch it at 123456 but I doubt I’ll manage to time it right lol
       
 (DIR) Post #B5TCukipJadvYs4RBg by rl_dane@polymaths.social
       0 likes, 0 repeats
       
       @roguefoamThe toot counter? Where do you see that?
       
 (DIR) Post #B5TCukskigaC3eiMeu by roguefoam@polymaths.social
       0 likes, 0 repeats
       
       @rl_dane https://polymaths.social/aboutI had pulled it up out of curiosity lol
       
 (DIR) Post #B5TCul0CH0XOQkCJGK by rl_dane@polymaths.social
       0 likes, 0 repeats
       
       @roguefoamI'm not obsessed or anything, what do you mean?!?alias pmcount='curl -sL "https://polymaths.social/about" |grep "\<count\>" |grep -oE "[0-9]{6}"'@amin
       
 (DIR) Post #B5TCulENQHsd8ipdMe by amin@polymaths.social
       0 likes, 0 repeats
       
       @rl_dane @roguefoamJust use the API, dude! /api/v1/instance has that info right there for you.
       
 (DIR) Post #B5TCulQ4inEnj0IybA by mirabilos@toot.mirbsd.org
       0 likes, 0 repeats
       
       @amin @rl_dane @roguefoam … unless randomised by a certain config entry :D
       
 (DIR) Post #B5YNVRSvqKhjsxZLfc by rl_dane@polymaths.social
       0 likes, 0 repeats
       
       @amin @roguefoamAllrighty then! ;)function pmcount {    #count polymaths statuses    curl -sL "https://polymaths.social/api/v1/instance" |grep -oE '"status_count":[0-9]{6,},' |tr -dc "0-9\n"}Don't gripe at me for not using jq when grep does the job perfectly XD
       
 (DIR) Post #B5YNVRvI8tODIupzsG by amin@polymaths.social
       0 likes, 0 repeats
       
       @rl_dane @roguefoamNot gonna gripe about that. Was just griping about you parsing a human-intended HTML page when machine-readable JSON was available.
       
 (DIR) Post #B5YNVSE512Q0FBd09w by rl_dane@polymaths.social
       0 likes, 0 repeats
       
       @amin @roguefoamOk, who's was the 123,456th toot, then?
       
 (DIR) Post #B5YNVSRuBdTew462i0 by dm@polymaths.social
       0 likes, 0 repeats
       
       @rl_dane @amin @roguefoam I hope it was part of a hellthread!
       
 (DIR) Post #B5YNVSh9GxfdhLEDT6 by amin@polymaths.social
       0 likes, 0 repeats
       
       @dm @rl_dane @roguefoamProbably a boost.Hang on, I'm figuring out the best way to do this.
       
 (DIR) Post #B5YNVSsUamkEGWXH9M by amin@polymaths.social
       0 likes, 0 repeats
       
       @dm @rl_dane @roguefoamRight now I'm downloading the code so I can figure out how it checks the status count.
       
 (DIR) Post #B5YNVTMcmkqblydL7I by amin@polymaths.social
       0 likes, 0 repeats
       
       @dm @rl_dane @roguefoamOh, there's a view in the database named "statuses_local_count_view". XDOkay, now I need to figure out how that view is generated.
       
 (DIR) Post #B5YNVTa5yfcgRkw676 by amin@polymaths.social
       0 likes, 0 repeats
       
       @dm @rl_dane @roguefoamOkay, that's a nifty postgres utility.polymaths=# \d+ statuses_local_count_view                 View "public.statuses_local_count_view" Column |  Type  | Collation | Nullable | Default | Storage | Description --------+--------+-----------+----------+---------+---------+------------- count  | bigint |           |          |         | plain   | View definition: SELECT count(*) AS count   FROM statuses  WHERE statuses.local = true AND (statuses.visibility = ANY (ARRAY[2, 3, 4, 5])) AND statuses.pending_approval = false;
       
 (DIR) Post #B5YNVTsWs8MtMvYoqW by irgndsondepp@gts.da-miez.de
       0 likes, 0 repeats
       
       @amin say... Now that I know you're using postgres, I was wondering if you ever had any timeouts when searching for posts.I run into that almost every time I search for something on my GoToSocial instance using SQLite. Retrying the search often works, because GtS caches the search response, but the timeouts are super annoying. But I'd rather not go through an unsupported migration to postgres without knowing that it fixes the issue.@dm @rl_dane @roguefoam
       
 (DIR) Post #B5YNVUE9ZjfKRzg5YG by amin@polymaths.social
       0 likes, 0 repeats
       
       @irgndsondepp @dm @rl_dane @roguefoamSometimes, yeah, and I definitely saw it more often before I moved to my current server, which is a little overpowered.Last time I talked to a GtS dev they said search is just something they haven't put much dev time into optimizing yet.
       
 (DIR) Post #B5YNVUSKj10Z9yJPea by irgndsondepp@gts.da-miez.de
       0 likes, 0 repeats
       
       @amin Alright, good to know. Then I'll stick with SQLite for now. Apart from search, I'm very happy with the performance of my little server. 😁@dm @rl_dane @roguefoam
       
 (DIR) Post #B5YNVUdK49nZi3SBma by amin@polymaths.social
       0 likes, 0 repeats
       
       @irgndsondepp @dm @rl_dane @roguefoamOne thing I will say about my experience with postgres; switching from a server using hard drives to one using solid state was a huge performance boost in about every area.
       
 (DIR) Post #B5YNVUmBXCt69XbGb2 by rl_dane@polymaths.social
       0 likes, 0 repeats
       
       @amin @irgndsondepp @dm @roguefoamSearching for users is still really frustrating. Interestingly, some clients seem to do it better than others. Moshidon, for example, is a lot faster than Tusky. No idea why.
       
 (DIR) Post #B5YNVUvkxcXmdE4uW0 by mirabilos@toot.mirbsd.org
       0 likes, 0 repeats
       
       @roguefoam @irgndsondepp @rl_dane @dm @amin local caches, like in Pinafore vs. (slow) FediText
       
 (DIR) Post #B5YNbs4xo9bwAAQLCq by mirabilos@toot.mirbsd.org
       0 likes, 0 repeats
       
       @rl_dane @dm @roguefoam @amin @irgndsondepp another problem is that clients like Pinafore time out the search after 20s when GtS’ webmodule times out after 60s and GtS’ core goes on for even longer, in the theory