Home | Notifications | New Note | Local | Federated | Search | Logout

Federated Timeline


Reply to @mametsuko@mk.absturztau.be classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:30:10) https://retreat-vienna.com/

​:meowmeltlove:​

Reply to @mametsuko@mk.absturztau.be classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:29:15) the studio, very beautiful ​:kroos_love:​ ---Attachments--- image: https://misskey-taube.s3.eu-central-1.wasabisys.com/files/0c8958ad-bc44-4f63-8a1c-686272190a53.webp

Reply to @eal@shinonome.technology classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:27:57) @eal@shinonome.technology partly yes...

Reply to @twinspin6@outerheaven.club classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:27:44) @twinspin6@outerheaven.club what!?

Reply to @mametsuko@mk.absturztau.be twinspin@twinspin6@outerheaven.club (2026-09-02 05:27:30) @mametsuko not the Neubaugasse πŸ’€ 😭

Reply to @mametsuko@mk.absturztau.be boreal@eal@shinonome.technology (2026-09-02 05:26:26) @mametsuko you went to a yoga class for the building?

classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:25:05) the best yoga class I had was in Neubaugasse, Vienna. the building was aesthetically pleasing ​:fernhappy:​

Reply to @sleepybisexual@mk.absturztau.be cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com (2026-09-02 05:23:51) @sleepybisexual@mk.absturztau.be its okay ​:neocat_hug_bot_heart:​

Reply to @nileane@nileane.fr NilΓ©ane@nileane@nileane.fr (2026-09-02 05:23:45) *sigh* and now let's find an alternative to migrate to

(please refrain from giving me advice <3, I'm aware of all the main available options) ---Attachments--- image: https://cdn.nileane.fr/media_attachments/files/117/197/650/213/996/773/original/6e4219daf2fc6fa0.png

Reply to @steph@fedi.steph.tools classic mametschko@mametsuko@mk.absturztau.be (2026-09-02 05:21:12) @steph@fedi.steph.tools ben je nooit naar Luxemburg geweest ​:exusiai_stare:​?

classic mametschko@mametsuko@mk.absturztau.be boosted: @steph@fedi.steph.tools (2026-09-01 16:28:43) https://mk.absturztau.be/notes/aqluzpoafipe00so ---Attachments--- image: https://fedi.steph.tools/system/media_attachments/files/117/194/601/454/214/195/original/83f8aa100eb2ef69.png

Mike Cox@mikecox@mastodon.iow.social (2026-09-02 05:15:41) Your throw!
#cat #dog
#dogsOfMastodon
#catsOfMastodon
#goldenRetriever ---Attachments--- image: https://s3.eu-west-2.amazonaws.com/iowmast/media_attachments/files/117/197/612/945/413/598/original/6bebb32da211085a.jpg

Reply to @silverpill@mitra.social Phantasm@phnt@fluffytail.org (2026-09-02 05:12:05) @silverpill @mischievoustomato @pwm @kirby @p @lain @meso @graf @pernia Pleroma basically took the completely opposite extreme to what Mastodon did (normalizing everything into a very specific schema). The Pleroma schema is very simple and mostly stores raw AP Activities/Objects which causes the size difference per-post/reaction. What Mitra stores in a separate table (post content, visibility,...), Pleroma stores in a single jsonb column. reaction count, repeat count, like count, tags are all stored in the same jsonb blob along the original AP Object representation. There are some advantages to that, like not needing a join across different tables. jsonb is also slightly larger because it is a pre-parsed json representation.

The split activities/objects table schema also introduced more DB size as there are more indexes needed for it to work. It's too late to deeply optimize and normalize the schema now, maybe with the eventual Pleroma 3.0 some day in the likely distant future and an hours/days long data migration.

stephantho@stephantho@mastodon.social (2026-09-02 05:10:31) #hamburg #dogsofmastodon #foto ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/589/111/054/970/original/bb57c45485193593.png

Ripperdoc. Miya Ironami@iro_miya@mk.absturztau.be (2026-09-02 05:06:05) Wonder if there's any job at all I could do in Germany without speaking German and without any experience at all (nor driver's license)

GeekAviator@GeekAviator@mastodon.social (2026-09-02 05:02:07) BEST FRIENDS πŸ’šπŸ’šπŸ’š #mastodon #fediverse #friends #dogdad #dog #dogs #dogsofmastodon #DogsOfFedi #dogsofpixelfed #dogstodon #dogslife #photo #photography #photos #photographie #photooftheday ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/552/699/481/458/original/7f7c5f0f993b3c98.png

Reply to @pernia@ryona.agency silverpill@silverpill@mitra.social (2026-09-02 04:59:51) @pernia @mischievoustomato @pwm @phnt @kirby @p @lain @meso @graf You're right, mitra stores most data in a normalized form. Reactions are not just a number though, there is a separate table for them: https://codeberg.org/silverpill/mitra/src/commit/c2d3697c3fa0bf1ae41575504094ee340ce16c12/mitra_models/migrations/schema.sql#L256-L268

We also store some raw activities and objects, but they are pruned aggressively and don't take much space.

This may explain the difference in database sizes, I don't know enough about pleroma to say for sure.

GeekAviator@GeekAviator@mastodon.social (2026-09-02 04:53:59) DOG YOGA! #mastodon #fediverse #yoga #dog #dogs #dogsofmastodon #pets #photo #photography #photos #DogsOfFedi #dogsofpixelfed #doglovers #viral #Tuesday ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/524/992/095/479/original/5cc7c620a88d6340.png

GeekAviator@GeekAviator@mastodon.social (2026-09-02 04:50:24) TAKE A DEEP BREATH! #mastodon #dogsofmastodon #dog #dogs #DogsOfFedi #dogsofpixelfed #fediverse #golden #pets #photo #photography #photos #photographie #photooftheday #photographer ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/510/975/862/319/original/56ba32e8eee52cba.png

ivy@ivy@misskey.id (2026-09-02 04:49:10) misplaced ivy's watch so he'd spent the day not knowing what time it was half of the time

Kaia@kaia@pleroma.soykaf.com (2026-09-02 04:44:53) what's the oldest torrent one can still download? :ElainaWonders:

ivy@ivy@misskey.id (2026-09-02 04:44:06) it's september
IT'S WHAT

Reply to @Nyx@mastodon.minionflo.net lilja@kayttaja@plush.city (2026-09-02 04:37:50) @Nyx ---Attachments--- image: https://cdn.masto.host/plush/media_attachments/files/117/197/468/549/375/984/original/8fb63abe34c9baf1.jpeg

Reply to @kayttaja@plush.city Ibuprofen Audio [verschreibungspflichtig]@Nyx@mastodon.minionflo.net (2026-09-02 04:37:20) @kayttaja pics or it didnt happen

lilja@kayttaja@plush.city (2026-09-02 04:36:34) transmission towers,,,

Dr. Lucky Tran@luckytran@mastodon.social (2026-09-02 04:34:56) Mamdani has announced that NYC restaurants can have outdoor dining all year round.

This is actually a big public health win because fall and winter is when respiratory virus cases surge. Dining outdoors helps reduce the risk of disease spread.

The News Desk@thenewsdesk@flipboard.com (2026-09-02 04:27:38) Israel warns it will retaliate if UK imposes sanctions
https://www.bbc.co.uk/news/articles/cr7degkkv5go?utm_source=flipboard&utm_medium=activitypub

Posted into Mideast Conflict @mideast-conflict-thenewsdesk

Giliell@Giliell@mastodon.social (2026-09-02 04:22:32) Ich glaube, dem Hund geht es gut.
#hunde #hundeleben #dogsofmastodon ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/403/995/600/505/original/18fb8d9f900a3344.jpg

Reply to @cheeseburgerally@plasmatrap.com lunya :neocat_flag_plural::neobot_floof_devil:@sleepybisexual@mk.absturztau.be (2026-09-02 04:16:25) @cheeseburgerally@plasmatrap.com I'm sorry for crashing out earlier

cheeseburgerally :neocat_rainbow:@cheeseburgerally@plasmatrap.com boosted: @GroupNebula563@mastodon.social (2026-09-02 04:05:42) oh EAT SHIT ---Attachments--- image: https://files.mastodon.social/media_attachments/files/117/197/340/692/471/955/original/8fc2f10443f45dbc.png
Older Notes