Mastodawn

[lien] The way CTRL-C in Postgres CLI cancels queries is incredibly hack-y - Lobsters (neon.com via runxiyu) #psql #gik #cli #db

Ctrl-C in psql gives me the heebie-jeebies - Neon

There are a few different reasons to hit the brakes on a Postgres query. Maybe it’s taking too long to finish. Maybe you realised you forgot to create an index that will make it orders of magnitude quicker. Maybe there’s some reason the results are no longer needed. Or maybe you, or your LLM buddy, […]

Neon

DocYeet

Mar 22

Had to do a maintenance on Immich, postgres cluster got disconnected from the operator (somehow?) and wouldn't scale past 1 replica anymore...

And we don't like single points of failure here

So first, descheduling the Immich pod, to avoid weird writes between last backup and actual DB shutdown

Triggering a manual backup

Deleting cluster

Recovering cluster from last backup

Woops, the shared library object name got renamed from vectorchord 0.3 to 0.4.3, now it's "vchord.so" instead of "vectors.so"

Quick fix and boom, everything comes back up

Restoring Argo auto sync and the cluster is all back up, distributed and shining

When Backups, DevOps and GitOps come back in a smooth and clear motion ⭐

#postgresql #postgres #cnpg #psql #selfhosted #selfhosting #homelab #k3s #kubernetes #linux #opensource #immich #vectorchord #backup #devops #argocd #gitops

Jiří Činčura ↹Mar 21

Blogged: FbNetExternalEngine 7.0 released

https://www.tabsoverspaces.com/id/233965

#firebird #dotnet #databases #database #psql

FbNetExternalEngine 7.0 released

Step forward for FbNetExternalEngine today – version 7.0 is ready, you can go and download it right now.

tabs ↹ over ␣ ␣ ␣ spaces by Jiří {x2} Činčura

nico Mar 11

[lien] Lock Monitoring - PostgreSQL wiki #psql #tips #gik #cli #db

Lock Monitoring - PostgreSQL wiki

nico Mar 7

[lien] The Internals of PostgreSQL - Lobsters (interdb.jp via BinaryIgor) #psql #gik #db

The Internals of PostgreSQL : Introduction

This document describes the internals of PostgreSQL for database administrators and system developers.

nico Mar 4

[lien] It’s 2026, Just Use Postgres | Tiger Data #psql #gik #db

It’s 2026, Just Use Postgres | Tiger Data

Stop managing multiple databases. Postgres extensions replace Elasticsearch, Pinecone, Redis, MongoDB, and InfluxDB with BM25, vectors, JSONB.

Tiger Data Blog

nico Feb 22

[lien] Upgrading PostgreSQL in place on FreeBSD - Dan Langille's Other Diary #psql #gik #bsd #db

Upgrading PostgreSQL in place on FreeBSD – Dan Langille's Other Diary

nico Feb 21

[lien] pgagroal/pgagroal: High-performance connection pool for PostgreSQL #psql #gik #db

GitHub - pgagroal/pgagroal: High-performance connection pool for PostgreSQL

High-performance connection pool for PostgreSQL. Contribute to pgagroal/pgagroal development by creating an account on GitHub.

GitHub

Reel Tubes Feb 21

Tara, aralin natin ang window functions sa PostgreSQL! Sa video na ito (70) ipapakita kung paano gamitin ang OVER() kasama ang RANK() at DENSE_RANK() sa psql — praktikal sa terminal at workflows. Perfect para sa mga Pinoy devs at DBAs na gustong mag-level-up! #PostgreSQL #SQL #WindowFunctions #RANK #DENSE_RANK #psql #Linux #Pinoy #Tagalog
https://apollo.lanofthedead.xyz/videos/watch/599097ff-5bf0-4c72-8f43-9fdddf98b464

70. Window function - OVER() with RANK() and DENSE_RANK()

PeerTube

nico Feb 13

[lien] UUID v7 – 80x moins d'I/O pour VACUUM #psql #gik #db