So damit sind alle Queues bis auf default leer; Diese hat noch 245.750, wird aber jetzt gut abgebaut.
Die Doppelten Einträge in preview_cards scheinen aber auch noch mal sehr relevant zu sein, dessen löschen scheint die DB ausgesprochen zu entlasten.
Zwei Festplatten auf einmal ausgestiegen und unvollständiges Backup. Was ein Albtraum.
https://status.anoxinon.de/status/anoxinon
#anoxinon #RAID #backup #datenbank #restore #postgres
Yehor 🇺🇦
@yehor@mastodon.glitchy.social
Tech nerd, full-stack developer, smart home enthusiast. Board games geek and sometimes a photographer. Star Trek, not Star Wars. Alliance, not Horde. #GlitchySocial owner and administrator: https://www.glitchy.social #SelfHosting in #Ukraine
mastodon.glitchy.social
My careless #Mastodon database optimization paid off. I now have slow queries.
Will try to revert #postgres config to default settings and start over.
#GlitchySocial #homelab #SelfHosted #selfhosting #selfhost
Hacker News
@hackernews@robot.villas
Top stories from Hacker News See old posts. I am a bot that mirrors an RSS feed. Source: https://news.ycombinator.com/rss
robot.villas
Postgres Queues Actually Scale
https://www.dbos.dev/blog/making-postgres-queues-scale
#HackerNews #Tech #Postgres
Jeroen Postma 🇪🇺
@jpostma@mastodon.clusterfucks.nl
#IT enthusiast, loves #gaming and #bouldering. Mostly wasting time on silly stuff.
mastodon.clusterfucks.nl
Upgraded the Mastodon backend postgresql server from 14 to 18 with pgautoupgrade. Found out that I had some uniqueness violations (possibly due to collation changes) that needed some manual DB operations to merge accounts and remove duplicate entries before I could run tootctl maintenance fix-duplicates. Then used pg_repack to remove bloat and finally used REINDEX to fix the last bits.
Everything's fresh and smooth again!
Hacker News
@hackernews@robot.villas
Top stories from Hacker News See old posts. I am a bot that mirrors an RSS feed. Source: https://news.ycombinator.com/rss
robot.villas
PGSimCity - an explorable 3D model that shows how Postgres works
https://github.com/NikolayS/pgsimcity
#HackerNews #Tech #Postgres
Hacker News
@hackernews@robot.villas
Top stories from Hacker News See old posts. I am a bot that mirrors an RSS feed. Source: https://news.ycombinator.com/rss
robot.villas
Postgres LISTEN/NOTIFY actually scales
https://www.dbos.dev/blog/postgres-listen-notify-scalability
#HackerNews #Tech #Postgres
Hacker News
@hackernews@robot.villas
Top stories from Hacker News See old posts. I am a bot that mirrors an RSS feed. Source: https://news.ycombinator.com/rss
robot.villas
The startup's Postgres survival guide
https://hatchet.run/blog/postgres-survival-guide
#HackerNews #Tech #Postgres
𝕤𝕖𝕝𝕖𝕒 
@selea@social.linux.pizza
Mostly tired - mostly breaking things Pretending to be a Sysadmin, GNU/Linux user since 2001, father of 3 current GNU+Linux users, lives in Sweden, Fascinated by strange hardware. I am not on vacation, but I am at the end of a long time delay. I am located somewhere on Earth, but as far as responding to toots is concerned, I appear to be at the edge of the solar system. boost != endorse #linux #gnu #sweden #fedi22 #unix Operatingsystems of choice: 
social.linux.pizza
I've had issues with Linux.Pizza's Matrix-server, mainly due to uncontrolled growth of the database. Even thou retention is set do one month, there is still an absurd amount of growth in the database.
I have never encountered this before, not even with thousands of active users.
I do know that other users had this issue before and have been vocal about it.
Is there any solution to this yet?
#matrix #linux #postgres
Postgres 19 Compression: from pglz to LZ4
https://www.crunchydata.com/blog/postgres-19-compression-from-pglz-to-lz4
#Databases #Postgres #Tech
Crazy-to-Bike
@crazy2bike@fediworld.de
leidenschaftlicher Biker | liebt Berge, Natur und Trails | Bikeguide | Materialfetischist | Camper | betreibt auch RC Modellbau | Datenschutz-Verfechter | Linux-Nutzer | Open-Source-Befürworter | Closed-Source und Tracking-Gegner | Ö-Arbeit/PR bei linuxmuster.net @mtb@fedigroups.social - Die Gruppe im Fediverse für alle Mountainbikenden. @fedibiker@fedigroups.social - Die Gruppe im Fediverse für alle Fahrradfahrende, egal ob Bio- oder E-Bike. #MTB #Mountainbike #Trails #Allmountain #Enduro #Camping #OpenSource #FOSS #Linux #Proxmox #Nextcloud #Joomla #HomeAssistant #Datenschutz #TeamDatenschutz #Modellbau #Wärmepumpe #ElektroAuto #Photovoltaik #erneuerbareEnergien #Energiewende #Demokratie #NoAfD #FckAfD #NoCDU #FckCDU #NoCSU #FckCSU
fediworld.de
Das ewige und immer weiter zunehmende #KatzUndMausSpiel bei in den letzten 20+ Jahren populären #CMS (#ContenManagementSystemen) aus Updaten und Patchen wegen #Sicherheitslücken, dann wieder höhere Versionen von #PHP und #mySQL / MariaDB bzw. #Postgres wegen Kompatibilität mit den Updates geht mir zunehmend auf den Sack.
Ich will deshalb perspektivisch meine #Joomla #Instanzen zu einer statischen #Webseite umbauen und dazu einen #SSG (#StaticSiteGenerator) nutzen. Eigentlich habe ich mich auch schon für #Hugo entschieden.
Die Daten der kleinsten Webseite habe ich auch bereits mit https://github.com/davetcc/hugojoomla aus der #Datenbank extrahiert.
Nun brauche ich noch ein schickes #Template. Ja, kann man selber bauen. Da würde ich aber durchaus wie schon bei Joomla ein paar Euro dafür in die Hand nehmen.
Da Hugo für mich absolutes Neuland ist, ist die Frage nach einem guten Anbieter für Hugo Templates - idealerweise einer, der auch mit dem Template kompatible Erweiterugen wie (falls das alles überhaupt mit einer statischen Seite möglich ist) #Slider, #Bildergalerie, #Akkordeon, #Kontaktformular, #FontAwesome, #Downloadverwaltung, #Kalender mit #Buchungssystem anbietet und - noch idealer, für gekaufte Produkte auch guten Support / Hilfestellung anbietet.
Zwar bin ich natürlich des Englischen mächtig, doch manches lässt sich in der Muttersprache einfacher klären, das i-Tüpfelchen wäre also deutschsprachiger Support.
Falls also jemand Erfahrungen, Kontakte, Ideen hat, die mir weiter helfen, immer her damit.
Bitte #Boost für mehr Reichweite.
How Multigres Supports LISTEN/NOTIFY Across Pooled Connections
https://multigres.com/
#Databases #Postgres #Tech
Check out the blog post on PeerSeek - a fast, privacy-respecting place to browse the federated PeerTube network. There are some details on how personalization works and technical background.
Find it here: https://polykit.rocks/peerseek-federated-peertube-search/
PeerSeek is live at https://peerseek.video/
#peertube #search #index #visibility #video #peerseek #fediverse #golang #postgres #kubernetes
Hacker News
@hackernews@robot.villas
Top stories from Hacker News See old posts. I am a bot that mirrors an RSS feed. Source: https://news.ycombinator.com/rss
robot.villas
Show HN: DBOSify - Drop-in Temporal replacement built on Postgres
https://github.com/dbos-inc/dbosify-py
#HackerNews #Tech #Postgres
Joel Wirāmu, Pauling
@jwp@cloudisland.nz
Pākehā with a strong Māori bi-cultural upbringing and Identity (Ngati Ngorongo - Taranaki hapu). Engineer, Geek, Psyc/Social researcher, Red hat employee. Always have an opinion, sometimes it's worth something ;-) Wellington, New Zealand based. May contain #dog #cat #electronics #linux & #social #psychology @aenertia on other things Unless otherwise noted any original media posted here is done so on a CC:BY:SA licence they/them/he
cloudisland.nz
Have pushed 0.9.5-dev branch to codeberg of foxing ( https://codeberg.org/aenertia/foxing/src/branch/0.9.5-dev ) in preparation for release tagging. A LOT of features and a couple of bug-fixes now the packet/file processing engine has stabilized ; including Semantic Routing to Parsers for Metadata Extraction and in-path Binary analysis using local ORT/BERT models ; letting you get semantic search powers for free when you copy something with foxingd/fxcp #linux #filesystem #bert #vectordb #postgres #xfs #stratis #blake3 #localllm
Shalien
@shalien@mastodon.projetretro.io
Avatar / Bannière ( PP / Banner) : https://patreon.com/u65011154?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=creatorshare_fan&utm_content=join_link Ailleurs : - Velours Profane (BDSM, NSFW) : https://discord.gg/7brs4pvB8V
mastodon.projetretro.io
Ryan Wild
@wild1145@mastodonapp.uk
Site Owner @mastodonapp.uk & @universeodon.com & @fedimedi.com If you wish to support the instances I look after feel free to donate over on our Ko-Fi Page: https://ko-fi.com/mastodonappuk or our Patreon https://www.patreon.com/universeodon My wonderful boyfriend: @PrinceMumbles Managing Director & Technical Architect @ ATLAS Media Group He / Him / His Views are always my own.
mastodonapp.uk
Hacker News 50
@hn50@social.lansky.name
Posts from https://news.ycombinator.com that have over 50 points. See also @hn100, @hn250 and @hn500
social.lansky.name
Postgres extension complements pgvector for performance and scale
Link: https://github.com/timescale/pgvectorscale
Discussion: https://news.ycombinator.com/item?id=46379765
#postgres
Hacker News 50
@hn50@social.lansky.name
Posts from https://news.ycombinator.com that have over 50 points. See also @hn100, @hn250 and @hn500
social.lansky.name
Lessons from a year of Postgres CDC in production
Link: https://clickhouse.com/blog/postgres-cdc-year-in-review-2025
Discussion: https://news.ycombinator.com/item?id=46332784
#postgres
You've seen all posts