Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://declin.eu/objects/62b59241-dbce-4484-9a74-c19441c71ca5">:blank: (i@declin.eu)'s status on Friday, 26-Apr-2024 18:34:25 JST</a><a href="https://declin.eu/users/i" title="i@declin.eu"><img src="https://gnusocial.jp/avatar/115368-48-20230428073129.webp" width="48" height="48" alt=":blank:" style="position: absolute; left: 0; top: 0;">:blank:</a><div><a href="https://poster.place/objects/111a41fd-8f9a-41ec-88c5-678c4e6be698" rel="in-reply-to">in reply to</a><ul><li><li><a href="https://gnusocial.jp/user/1610" title="admin@detroitriotcity.com">313Chris:hellokitty_headbang:</a></li><li><a href="https://gnusocial.jp/user/3517" title="christijunior@detroitriotcity.com">Christi Junior</a></li><li><a href="https://gnusocial.jp/user/136366" title="colonelj@bae.st"> J上校👮🇺🇦🏳️‍⚧️</a></li><li><a href="https://gnusocial.jp/user/255499" title="verita84eva@poster.place">Vivi Nella Verita</a></li></ul></div></section><article><a href="https://poster.place/users/verita84eva">@verita84eva</a> <a href="https://bae.st/users/colonelj">@colonelj</a> <a href="https://detroitriotcity.com/users/ChristiJunior">@ChristiJunior</a> <a href="https://detroitriotcity.com/users/admin">@admin</a> <a href="https://ryona.agency/users/mint">@mint</a> lol i think i know why, Create activities with more than 5000 mentions, i bet the indexing blows up too on them<br><br>like, <a href="https://writeworks.uk/@/the_kyiv_independent/">https://writeworks.uk/@/the_kyiv_independent/</a> created 13MB in the DB with just 100 activities<br><br>wonder what<br><br>select actor, pg_size_pretty(sum(pg_column_size(activities.*))), count(*) from activities group by actor order by sum(pg_column_size(activities.*)) desc limit 100;<br><br>says for you, and if there's not a really degenerate software bug out there silently killing ick'oma database</article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/2992956#notice-5950695">In conversation</a><time datetime="2024-04-26T18:34:25+09:00" title="Friday, 26-Apr-2024 18:34:25 JST">about 7 months ago</time> <span>from <span><a href="https://declin.eu/objects/62b59241-dbce-4484-9a74-c19441c71ca5" rel="external" title="Sent from declin.eu via ActivityPub">declin.eu</a></span></span><a href="https://declin.eu/objects/62b59241-dbce-4484-9a74-c19441c71ca5">permalink</a><h4>Attachments</h4><ol><li><article><header><div>Domain not in remote thumbnail source whitelist: writeworks.uk</div><h5><a href="https://writeworks.uk/@/the_kyiv_independent/">The Kyiv Independent [unofficial]'s Blog</a></h5><div></div></header><div>Unofficial posting for The Kyiv Independent daily update &amp; summary from Ukraine
Website: https://kyivindependent.com/
Need instant translation in your browser? 
Use the plug-in/extension ‘Translate Web Pages’ for either Firefox or Chromium browsers:Download for Firefox browsers
Download for Chromium based browsers then:Extract the zip file
Open your browser’s extension manager
Activate developer mode
Load the extension with the option “Load unpacked”
Alternatively, if your browser supports it, install directly from this crx file</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
:blank: (i@declin.eu)'s status on Friday, 26-Apr-2024 18:34:25 JST:blank:
in reply to
@verita84eva @colonelj @ChristiJunior @admin @mint lol i think i know why, Create activities with more than 5000 mentions, i bet the indexing blows up too on them

like, https://writeworks.uk/@/the_kyiv_independent/ created 13MB in the DB with just 100 activities

wonder what

select actor, pg_size_pretty(sum(pg_column_size(activities.*))), count(*) from activities group by actor order by sum(pg_column_size(activities.*)) desc limit 100;

says for you, and if there's not a really degenerate software bug out there silently killing ick'oma database
In conversationabout 7 months ago from declin.eupermalink
Attachments
1. Domain not in remote thumbnail source whitelist: writeworks.uk
  The Kyiv Independent [unofficial]'s Blog
  Unofficial posting for The Kyiv Independent daily update & summary from Ukraine Website: https://kyivindependent.com/ Need instant translation in your browser? Use the plug-in/extension ‘Translate Web Pages’ for either Firefox or Chromium browsers: Download for Firefox browsers Download for Chromium based browsers then: Extract the zip file Open your browser’s extension manager Activate developer mode Load the extension with the option “Load unpacked” Alternatively, if your browser supports it, install directly from this crx file

Public

Embed Notice

HTML Code

Corresponding Notice