#postgresql

@saaste@mementomori.social · May 07, 2026

Nörttikysymys tietokantaguruille. Kysymyksessä on PostgreSQL. Minulla on käsissä varsin monimutkainen tietokantarakenne. Yhteen tauluun (kutsutaan sitä nimellä A) liittyy 10 vierasavainta jotka ovat tyypiltaan CASCADE tai SET NULL. Kun A-taulusta poistetaan rivi, tietokanta joutuu tarkastamaan nuo 10 vierasavainta ja siivoamaan myös ne. Yli 90 % poisto-operaation suoritusajasta menee vierasavaimien aiheuttamaan siivousoperaatioon. Tarkastin, että jokaisessa vierastaulussa on asianmukainen indeksi paikoillaan. Kun A-taulussa on miljoona riviä, 1000 rivin poistaminen kestää noin sekunnin. Tämä tuntuu itsestä edelleen varsin hitaalta. Tällä tahdilla miljoonan rivin poistaminen kestäisi yli 16 minuuttia. Jos sinulle on kokemusta suurista tietokannoista, tuntuuko sekunnin suoritusaika sinusta kohtuulliselta kun muistetaan, että tietokantarakenne on kohtalaisen monimutkainen? Ja tuleeko mieleen jotain nerokkaita taikatemppuja, jolla poistoa saisi nopeutettua? #ohjelmointi #tietokannat #postgresql

3

6

5

0

hbrpgm

@hbrpgm@adalta.social · May 04, 2026

📺 https://peer.adalta.social/w/uJXFTsgU7ZVBNYCT6MgfAi 🔗 🇩🇪🇺🇸🇫🇷 🔗 ℹ️

Une analyse stratégique des implications de la cohérence quorum pour les architectures Postgres CloudNative.

#opensource #community #cloud #postgresql #kubernetes

0

jbz

@jbz@indieweb.social · Apr 30, 2026

🐘 How Linux 7.0 Broke PostgreSQL: The Preemption Regression Explained https://read.thecoder.cafe/p/linux-broke-postgresql #PostgreSQL #linux #kernel #Preemption

2

0

6

0

Larvitz

@Larvitz@mastodon.bsd.cafe · Apr 14, 2026

Latest quarterly FreeBSD package upgrade broke my Nextcloud 😮‍💨

Post mortem: The new version of php85-pdo_pgsql is now compiled against PostgreSQL 18, not 17. So pkg upgrade removed postgresql17-server, leaving Nextcloud dysfunctional without a database.

Solution:

Reinstalled postgresql17-server
Dumped the db with pg_dump
Installed postgresql18-server & php85-pdo_pgsql
Copied over pg_hba.conf & postgresql.conf
Created empty db/user in PG18
Imported the db dump
Ran occ maintenance:data-fingerprint

Restarted php-fpm & nginx

All fine again. But that was unpleasant 🙂

#SysAdmin #SelfHosted #FreeBSD #Nextcloud #Postgresql

23

7

14

0

Thomas

@tmuwa@burningboard.net · Apr 12, 2026

https://tabularis.dev/ A great project with a dedicated maintainer.Definitly check it out if you need a graphical #database client for #PostgreSQL, #MySQL/#MariaDB or #SQLite. And yes I contributed one or two little commits myself. 😜

0

Guia de TI

@guiadeti@flipboard.social · Feb 26, 2026

Certificação em Bancos de Dados Relacionais da freeCodeCamp: Curso Gratuito com Projetos Práticos https://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/ #bancodedados #bash #certificacao #freecodecamp #postgresql #programacao #sql https://guiadeti.com.br/certificacao-bancos-de-dados-relacionais-freecodecamp/?fsp_sid=1050

0

socallinuxexpo

@socallinuxexpo@social.linux.pizza · Feb 23, 2026

Speaker Spotlight: Henrietta Dombrovskaya PostgreSQL and Academia—Establishing Partnership Watch the full talk: https://youtu.be/6sgV0UxZw5Y?si=eFG9FQs67e0ImYey Join us at SCaLE 23x to explore how open source is transforming education! 🚀 #SCaLE23x #OpenSource #PostgreSQL #SoCalLinuxExpo

1

0

Jobs for Developers

@jobsfordevelopers@mastodon.world · Feb 23, 2026

SoFi is hiring Staff Software Engineer, Member 🔧 #java #kotlin #kubernetes #postgresql 🌎 San Francisco, California ⏰ Full-time 🏢 SoFi Job details https://jobsfordevelopers.com/jobs/staff-software-engineer-member-at-sofi-com-jan-23-2026-5515c0?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting #jobalert #jobsearch #hiring

0

1

0

Rafael Pérez 🌱

@rperezrosario@mastodon.social · Feb 19, 2026

Tiger Data author Raja Rao makes a pretty good case for reducing operational complexity by using a single database server (PostgreSQL) to supplant non-relational use cases that were previously handled by the likes of Elasticsearch, Redis, and MongoDB to name a few. He goes on to list and explain the different PostgreSQL extensions that can provide equivalent services without the database sprawl. "It's 2026, Just Use Postgres" https://www.tigerdata.com/blog/its-2026-just-use-postgres #programming #sql #postgresql #databases

3

0

4

0

Semur Jengkol

@semurjengkol@misskey.sangeunahna.com · Feb 21, 2026

Sip, #postgresql #replication antar data center instance misskey ini dah beres. Yuk kita lanjut ibadah alias tidur disaat puasa.

0

1

0

Tiago F

@tiagojferreira@bolha.us · Feb 21, 2026

PostgreSQL sustentando 800 milhões de usuários na OpenAI https://openai.com/pt-BR/index/scaling-postgresql/ #postgresql #CodigoAberto #SoftwareLivre

0

1

0

Fox

@fox@cytag.nl · Feb 11, 2026

Renaming a table in SQL Since I am currently overhauling many websites, I needed in one particular case to rename a table. Never needed this before, I searched and found the following. Bog-standard SQL (which worked for me) RENAME TABLE ohu1y_docman_file_counts TO ohu1y_docman_file_counts_bak; PostgreSQL / SQLite ALTER TABLE ohu1y_docman_file_counts RENAME TO ohu1y_docman_file_counts_bak; --- https://3xn.nl/projects/2026/02/11/renaming-a-table-in-sql/ --- #mysql #postgresql #rename #sqlite #table

1

0