Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://eientei.org/objects/f47d126f-85a8-4cc4-85b7-aee67cc8a96a">Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 19:32:44 JST</a><a href="https://eientei.org/users/grips" title="grips@eientei.org"><img src="https://gnusocial.jp/avatar/179734-48-20230927084050.webp" width="48" height="48" alt="Иоанн Павел Грипс" style="position: absolute; left: 0; top: 0;">Иоанн Павел Грипс</a></section><article><p>starting to feel like a fucking failure</p><p>I think I'll try to safely terminate the query. I'm not a database expert but that triple left join looks inefficient as hell, especially when</p>pleroma=# SELECT count(*) FROM public.activities;
   count   
-----------
 105514556
(1 row)
<p>I hope it was actually deleting rows all along and not just calculating what to delete. that would mean 13 wasted days</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/4951160#notice-9700912">In conversation</a><time datetime="2025-04-25T19:32:44+09:00" title="Friday, 25-Apr-2025 19:32:44 JST">about a year ago</time> <span>from <span><a href="https://eientei.org/objects/f47d126f-85a8-4cc4-85b7-aee67cc8a96a" rel="external" title="Sent from eientei.org via ActivityPub">eientei.org</a></span></span><a href="https://eientei.org/objects/f47d126f-85a8-4cc4-85b7-aee67cc8a96a">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/4522715">Untitled attachment</a></label><br><a href="https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png" rel="external">https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png</a></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Иоанн Павел Грипс (grips@eientei.org)'s status on Friday, 25-Apr-2025 19:32:44 JST Иоанн Павел Грипс
starting to feel like a fucking failure
I think I'll try to safely terminate the query. I'm not a database expert but that triple left join looks inefficient as hell, especially when
pleroma=# SELECT count(*) FROM public.activities; count ----------- 105514556 (1 row)
I hope it was actually deleting rows all along and not just calculating what to delete. that would mean 13 wasted days
In conversationabout a year ago from eientei.orgpermalink
Attachments
1. Untitled attachment
  https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png

Public

Embed Notice

HTML Code

Corresponding Notice