Tootfinder

from my link log —
Faster asynchronous WAL archiving with pgBackRest to avoid PostgreSQL WAL backlog.
https://www.percona.com/blog/2020/12/01/how-pgbackrest-is-addressing-slow-postgresql-wal-archiving-using-…

How pgBackRest is Addressing Slow PostgreSQL WAL Archiving Using Asynchronous Feature
How pgBackRest is addressing slow PostgreSQL WAL Archiving using its Asynchronous archiving feature.

A quick shadow drop of sorts: who hasn't implemented a cache on top of Postgres? I know, everyone has. And yet, here's another contender that's based on psycopg and can use existing SQLAlchemy engines (or whatever you implement): ⚡️psycache ⚡️
In my defence, when I wrote it (it's been in prod for years) there weren’t quite as many other implementations and the deep support for instrumentation sets this one apart, I think.
And thus Hynek's Summer of Postgres ha…

GitHub - hynek/psycache: A psycopg-Backed PostgreSQL Cache
A psycopg-Backed PostgreSQL Cache. Contribute to hynek/psycache development by creating an account on GitHub.

from my link log —
Updating the PostgreSQL root.crt file for TLS client auth.
https://www.2ndquadrant.com/en/blog/updating-the-postgresql-root-crt-file/
saved 2020-08-25

EDB Home - EDB Postgres AI
Join the era of Sovereign AI with EDB Postgres. Simplify your hybrid architecture, gain insights, and access training from leading Postgres experts.

For folks considering converting their #Nextcloud database from MariaDB (or MySQL) to PostgreSQL: it is possible, there is a built-in tool, but there are also some bugs and gotchas along the way. Our Nextcloud DB has millions of records and takes hours to convert, so the try->find bug->clean DB or patch tool->clean target->try again cycle has now taken up three days of two Byobu screens. …

from my link log —
Removing PostgreSQL bottlenecks caused by high traffic.
https://www.percona.com/blog/2020/05/29/removing-postgresql-bottlenecks-caused-by-high-traffic/
saved 2020-06-03

Removing PostgreSQL Bottlenecks Caused by High Traffic
Percona's Robert Bernier writes about removing PostgreSQL bottlenecks caused by high traffic.

PostgreSQL 18 brings real changes to how constraints work. Gülçin Yıldırım Jelinek (PostgreSQL contributor, Xata) is at #bbuzz26 to walk through what you should know if you're running Postgres in production.
Learn more about this session: https://2026.berlinbuzzwords.de/session/what-you-should-know-about-constraints-in-postgresql-18/

For the first time, I tried the "Fix with Copilot" button. I used it for the most trivial thing: changing 'Postgresql' to 'PostgreSQL' in a comment.
And this obscure error happened:
Failed to Fix with Copilot. Please try again. (422)
(I tried again, it failed again.)
I thought that maybe it could be faster than me manually fixing the capitalisation of PostgreSQL in the source file. Turns out it was not since
1. It did not work at all
2. I took that screenshot and wrote that rant
3. I fixed it manually anyway
Shit like that is not going to improve my opinion of AI (which isn’t very high to begin with).

from my link log —
Seamless application failover using libpq features in PostgreSQL.
https://www.percona.com/blog/2019/10/23/seamless-application-failover-using-libpq-features-in-postgresql/
saved 2019-10-30

Seamless Application Failover using libpq Features in PostgreSQL
Percona's Avinash Vallarapu talks about seamless application failover using libpq features in PostgreSQL, and how even with some slowness it still helps.

🐘 #pgrust is #PostgreSQL rewritten from scratch in #Rust — an experimental, AI-assisted project exploring what Postgres could look like built on modern primitives.

from my link log —
What is FETCH FIRST WITH TIES in PostgreSQL 13?
http://sqlservercode.blogspot.com/2020/05/postgresql-adds-fetch-first-with-ties.html
saved 2020-05-27

PostgreSQL adds FETCH FIRST WITH TIES.. just like TOP n WITH TIES in SQL Server
PostgreSQL 13 Beta 1 was released yesterday, you can read the release notes here https://www.postgresql.org/about/news/2040/ One thing t...

Daniel Seybold (co-founder of benchANT) is at #bbuzz26 to ask whether PostgreSQL is now a genuine option for analytical workloads, and what the benchmarks actually show.
Learn more: https://2026.berlinbuzzwords.de/session/from-oltp-to-olap-is-postgresql-eating-analytics-too/
Get your ticket: https://2026.berlinbuzzwords.de/tickets/

from my link log —
Tips for PostgreSQL bulk data loading.
https://www.2ndquadrant.com/en/blog/7-best-practice-tips-for-postgresql-bulk-data-loading/
saved 2020-09-16

EDB Home - EDB Postgres AI
Experience EDB Postgres AI, the world's first sovereign AI & data platform. Manage, observe, and operationalize your data for optimized AI strategies.

In which I introduce my new project
#sql #postgreSQL

Introducing Retrofit | Chris K Wensel
Introducing Retrofit, a CLI that records database schema evolution as logical, identity-preserving operators instead of hand-written DDL migrations.

Edit: question answered successfully! Ty!
OK folks, I need some #docker advice for those gurus out there. A boost would be appreciated to get it in front of knowledgeable eyes.
I have a container running postgresql for mastodon. I would like to tweak the conf file for postgresql now that I have things going.
What is the safest way to do this on a running container?
Can I stop the instance with docker stop and then restart it and it will simply see the new postgresql.conf specified in the original docker run command?
I'm getting more comfortable with docker.. but not *that* comfortable, so I'm still worried that if I restart it'll break somehow lol.
I want to make sure I do this right so I don't wreck what appears to be a running and reasonably happy container :)
I'm running docker in a colima virtual machine on macOS.
#mastoAdmin #docker #colima #postgresql

🔌 Non-blocking I/O for regular #PHP functions. fread, fwrite, file_get_contents, ob_start, curl, #MySQL, and #PostgreSQL now work asynchronously without extra effort.
🖥️ Built-in TrueAsync S…

Kirby – Das elegante Flat-File CMS
https://graffiti.bayerwald.social/my-blog/mein-erster-test-artikel

Kirby – Das elegante Flat-File CMS
Kirby ist ein modernes Content Management System, das sich von der Masse der SQL-Datenbanken abhängig machenden Lösungen deutlich unterscheidet. Statt MySQL oder PostgreSQL nutzt Kirby das sogenannte

from my link log —
OLTP performance since PostgreSQL 8.3.
https://www.2ndquadrant.com/en/blog/oltp-performance-since-postgresql-8-3/
saved 2020-10-08

EDB Home - EDB Postgres AI
Explore EDB Postgres AI's solutions, gain insights from experts, and learn about AI strategy behind 5x ROI. Sign up for interactive sessions & download insightful reports.

« J'ai découvert Beads, Dolt et DoltgreSQL »
#Git #PostgreSQL

from my link log —
PostgreSQL is a great pub/sub and job server.
https://webapp.io/blog/postgres-is-the-answer/
saved 2021-12-18 https://

Postgres is a great pub/sub & job server
If you need a publish/subscribe or job server at any point in your project, try using Postgres. It'll give you lots of data integrity and performance guarantees, and it doesn't require you or your team learning any new technology.

🐘 #Microsoft open-sourced #pgdurable, a new #PostgreSQL extension that brings durable execution directly into the database — long-lived, fault-tolerant workflows run inside

from my link log —
sqldef: idempotent MySQL/PostgreSQL schema management.
https://github.com/k0kubun/sqldef
saved 2019-09-04 https://dotat.at/:/CMJ55.…

GitHub - sqldef/sqldef: Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server - sqldef/sqldef

🚀 Fits vector embedding pipelines (chunk, embed, upsert into #pgvector), ingest/ETL jobs, scheduled DB maintenance and external API workflows. Released under the permissive PostgreSQL License — clone and run it anywhere
🌐

« J'ai découvert Beads, Dolt et DoltgreSQL »
#Git #PostgreSQL

from my link log —
Querying PostgreSQL tables from DuckDB.
https://duckdb.org/2022/09/30/postgres-scanner.html
saved 2022-09-30 https://

Querying Postgres Tables Directly from DuckDB
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.

from my link log —
PostgreSQL text search: balancing query time and relevancy.
https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/
saved 2021-10-21

from my link log —
LOAD "PL/CBMBASIC",8,1: Commodore 64 BASIC for PostgreSQL.
https://thombrown.blogspot.com/2026/07/load-plcbmbasic81-commodore-64-basic.html
saved 2026-07-06

success.
docker restart does not jeopardize anything as long as a volume is specified at runtime to preserve the data.
successfully restarted with new conf file and we're now green across the board and hopefully tuned for the slightly larger resources available from #newOldiMac
#docker #mastoAdmin #docker #colima #postgresql #selfhost

📊 Architecturally minimal: a Postgres extension plus a background worker, built on two Rust libraries — duroxide (orchestration runtime with deterministic replay & checkpoints) and duroxide-pg (Postgres-backed state provider). Runs on PostgreSQL 17

from my link log —
PostgreSQL PostGIS trajectories through space and time.
https://blog.rustprooflabs.com/2020/11/postgis-trajectory-intro
saved 2020-12-02

from my link log —
Potential consequences of using PostgreSQL as a job queue.
http://richyen.com/postgres/2026/05/04/postgres_job_queue.html
saved 2026-05-07

making a script to backup the postgresql and redis docker containers... so I can have this run everyday to ensure I don't lose anything if/when docker collapses.
I also noticed that the docker containers all use UTC time, which is annoying, and who knows maybe that has something to do with the instability? so i synced it to America/Vancouver
Also... I know "America" is the continent, not the country in this context. But there is more than one Vancouver on the American continent. Canada/Vancouver would be better, no?
#random #selfhost #mastoadmin #docker #colima

from my link log —
Performance tuning PostgreSQL for SquareSpace's TLS certificate service.
https://engineering.squarespace.com/blog/2019/performance-tuning-postgres-within-our-tls-infrastructure
saved 2019-08…

Performance Tuning Postgres within our TLS Infrastructure — Squarespace Engineering Blog
At Squarespace, the Edge team manages the TLS infrastructure, which handles the life cycle of millions of SSL certificates used by our customers. This makes us one of the largest users of Let’s Encrypt , a free, automated, and open certificate authority (CA).