Lemmy is incredibly unique in it’s stance of not using Redis, Memcached, dragonfly… something. And all the CPU cores and RAM for what this week is reported as 57K active users across over 1200 Instance servers....
post primary key has gaps in it, the sequence is being used for transactions that are later canceled or some kind of orphan posts? This is observable from incoming federation posts from other instances....
This is the first post or comment in Lemmy history to say log_min_duration_statement … ;)...
I thought some people were out there in June creating stress-testing scripts, but I haven’t seen anything materializing/showing results in recent weeks?...
IIRC, it was lemmy.ca full copy of live data that was used (copy made on development system, not live server - if I’m following). Shared Saturday July 22 on GitHub was this procedure:...
Right now querying posts has logic like this:...
A general description of the proposed change and reasoning behind it is on GitHub: github.com/LemmyNet/lemmy/issues/3697...
in Communities create community/edit community there is a SiteLanguage::read with no site_id, should that call to read have site_id = 1?...
Over a short period of time, this is my incoming federation activity for new comments. pg_stat_statements output being show. It is interesting to note these two INSERT statements on comments differ only in the DEFAULT value of language column. Also note the average execution times is way higher (4.3 vs. 1.28) when the language...
Given how frequent these records are created, every vote by a user, I think it is important to study and review how it works....
Details here: github.com/LemmyNet/lemmy/issues/3165...
Can we get some Rust guys to chime in on the SQL wrapping that Rust is doing?...