Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://blob.cat/objects/65fadc38-8698-4a76-972f-9aa4a5911480">:blobcathug: (jain@blob.cat)'s status on Tuesday, 12-Dec-2023 03:18:56 JST</a><a href="https://blob.cat/users/Jain" title="jain@blob.cat"><img src="https://gnusocial.jp/avatar/4294-48-20220810062846.webp" width="48" height="48" alt=":blobcathug:" style="position: absolute; left: 0; top: 0;">:blobcathug:</a><div><a href="https://blob.cat/objects/4156a6e5-37c1-4b73-9b4b-622b0c82e1f5" rel="in-reply-to">in reply to</a><ul><li><li><a href="https://gnusocial.jp/user/222010" title="hanna@woem.men">Hanna</a></li><li><a href="https://gnusocial.jp/user/222147" title="ashten@woem.men">[evil] lvl. 99 cute lesbian vampire catgirl</a></li></ul></div></section><article><a href="https://woem.men/@ashten">@ashten</a> <a href="https://woem.men/@hanna">@hanna</a> that could be the issue but also not... <br>also pg_repack <a href="https://reorg.github.io/pg_repack/">https://reorg.github.io/pg_repack/</a> <a href="https://github.com/reorg/pg_repack">https://github.com/reorg/pg_repack</a> can help rebuilding the tables &amp; indexes while beeing live. So you can get rid of the bloat &amp; rebuild all indexes so you will get a neat &amp; fresh db...<br>there is one small issue i have with it, i can explain that if you are interested</article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/2440809#notice-4826872">In conversation</a><time datetime="2023-12-12T03:18:56+09:00" title="Tuesday, 12-Dec-2023 03:18:56 JST">about a year ago</time> <span>from <span><a href="https://blob.cat/objects/65fadc38-8698-4a76-972f-9aa4a5911480" rel="external" title="Sent from blob.cat via ActivityPub">blob.cat</a></span></span><a href="https://blob.cat/objects/65fadc38-8698-4a76-972f-9aa4a5911480">permalink</a><h4>Attachments</h4><ol><li><article><header><div>No result found on File_thumbnail lookup.</div><h5><a href="https://reorg.github.io/pg_repack/">pg_repack 1.4.8 -- Reorganize tables in PostgreSQL databases with minimal locks</a></h5><div></div></header><div></div><footer></footer></article></li><li><article><header><div>Domain not in remote thumbnail source whitelist: opengraph.githubassets.com</div><h5><a href="https://github.com/reorg/pg_repack">GitHub - reorg/pg_repack: Reorganize tables in PostgreSQL databases with minimal locks</a></h5><div></div></header><div>Reorganize tables in PostgreSQL databases with minimal locks - GitHub - reorg/pg_repack: Reorganize tables in PostgreSQL databases with minimal locks</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
:blobcathug: (jain@blob.cat)'s status on Tuesday, 12-Dec-2023 03:18:56 JST:blobcathug:
in reply to
@ashten @hanna that could be the issue but also not...
also pg_repack https://reorg.github.io/pg_repack/ https://github.com/reorg/pg_repack can help rebuilding the tables & indexes while beeing live. So you can get rid of the bloat & rebuild all indexes so you will get a neat & fresh db...
there is one small issue i have with it, i can explain that if you are interested
In conversationabout a year ago from blob.catpermalink
Attachments
1. No result found on File_thumbnail lookup.
  pg_repack 1.4.8 -- Reorganize tables in PostgreSQL databases with minimal locks
2. Domain not in remote thumbnail source whitelist: opengraph.githubassets.com
  GitHub - reorg/pg_repack: Reorganize tables in PostgreSQL databases with minimal locks
  Reorganize tables in PostgreSQL databases with minimal locks - GitHub - reorg/pg_repack: Reorganize tables in PostgreSQL databases with minimal locks

Public

Embed Notice

HTML Code

Corresponding Notice