Keyset Cursors, Not Offsets, for #Postgres Pagination https://blog.sequinstream.com/keyset-cursors-not-offsets-for-postgres-pagination/
#Postgres Extensions Ecosystem Mini-Summit #4: The User POV | Meetup https://www.meetup.com/postgres-extensions-ecosystem-mini-summits/events/306682918/
Fix #Postgres strchrnul Compile Error on #macOS 15.4 https://justatheory.com/2025/04/fix-postgres-strchrnul/
#PgDog is a #network #proxy and it can see every byte sent between #Postgres and the clients. It understands #SQL and can infer where queries should go, without requiring changes to application code. In this article, we discuss how we handle the Postgres wire protocol and manipulate it to serve queries to multiple databases at the same time. https://pgdog.dev/blog/hacking-postgres-wire-protocol
New short blog post powered by wine and a desire to check off a to-do item:
https://kdwarn.net/blog/installing-postgres-version-not-in-distro-packages
#Postgres FM | pg_stat_statements track_planning #podcast https://share.transistor.fm/s/729ade94
Ive built a setup for hosting websites which consists of:
* Host running #microos with #podman
* #Treafik and #sshpiper at the edge
* #Nginx, php-fpm, #mariadb + phpmyadmin + nginx or #postgres + dbadmin, openssh for each site
It actually works quite well, openssh keybased access is to transfer files into the containers, traefik does the reverse proxying.
I'm just wondering if its a sustainable and maintainable setup. Sometimes just going with a "standard" solution seems so much easier.
Hacking the Postgres Wire Protocol
Link: https://pgdog.dev/blog/hacking-postgres-wire-protocol
Discussion: https://news.ycombinator.com/item?id=43693326
Adding or dropping indexes 
in a live PostgreSQL database means locking the entire table, potentially causing application slowdowns or outages. Use CONCURRENTLY with CREATE INDEX or DROP INDEX to perform the operation in the background. #postgres
On June 12, join our CEO @c2main at 11:30 AM CEST for a FREE livestream @ @posetteconf regarding Pressure Stall Information within the world of #PostgreSQL.
Use this link to add the livestream to your calendar & optionally register, or follow us to get the recording after the conference when it becomes available!
posetteconf.com/2025/talks/resource-control-admission-i-have-a-date-with-my-psi/
Maintaining #Postgres for Modern Workloads https://xata.io/blog/maintainable-postgres-podcast
@ascherbaum I started using #Postgres at version 7.0 so I lived through the transition, but somehow I didn't realize that it had happened.
I imagine countless other Postgres users must go through similar groundbreaking transitions and not realize
@ascherbaum I think what actually happened before WAL was developed, was that we'd keep a list of files modified by the transaction and run fsync on them at commit time
#postgres
I recently leaned on an #LLM to help me get data out of a legacy database. The key was a multi-step prompt that took an existing schema and compressed it. That allowed me to build a chat bot that understood and could generate SQL for the answers I was seeking.
https://www.joecotellese.com/posts/llms-to-understand-legacy-database/
Today I discovered "lnav"or the Log Navigator cli utility. It is a truly awesome log follower and navigator for the terminal which works beautifully with PostgreSQL log files.
#postgres #postgresql #debugging #sql #plpgsql #lnav #logs #logging #rdbms #system #administration
Vector 0.46.0 now includes a #Postgres sink!
It's time to send my logs to TimescaleDB 
