#postgresql

16 posts · Last used 10d

Back to Timeline
saaste
@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
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
0
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
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
tmuwa
@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
0
0
guiadeti
@guiadeti@flipboard.social · Feb 26, 2026
0
0
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
1
1
jobsfordevelopers
@jobsfordevelopers@mastodon.world · Feb 23, 2026
0
0
1
rperezrosario
@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
semurjengkol
@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
tiagojferreira
@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
0
1
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
1
1
upscene
@upscene@mstdn.business · Feb 11, 2026
📣 New release of #DatabaseWorkbench now available! 🖥 Database Workbench is a developer tool for #SQLServer, #Firebird, #Oracle, #SQLite, #MySQL, #MariaDB, #PostgreSQL, #InterBase and #NexusDB. ⬇️ Grab your trial copy now. https://www.upscene.com/database_workbench/
0
0
0
jobsfordevelopers
@jobsfordevelopers@mastodon.world · Feb 06, 2026
2
0
0
jobsfordevelopers
@jobsfordevelopers@mastodon.world · Feb 02, 2026
0
0
0
phantasus
@phantasus@fedi.at · Jan 27, 2026
I'm a senior software developer who is proficient in #ruby #elixir #sql #java #linux #clang #javascript #python #postgresql #postgis #mqtt #rabbitmq I search for a #job and I reside currently in #austria #vienna and I'm fluent in #german and #english I love #foss #opensource and #rest #api Let's #getfedihired #gethired #hiring
13
0
59

You've seen all posts