Build Reliable Notifications with Postgres

Postgres를 활용해 신뢰성 높은 알림 및 메시징 시스템을 구축하는 방법을 소개합니다. 메시지를 Postgres 테이블에 저장하여 정확히 한 번만 전송 및 소비하는 원자적 워크플로우를 구현할 수 있으며, LISTEN/NOTIFY 기능을 활용해 효율적이고 저지연의 알림 수신을 지원합니다. 연결이 끊겼을 때 알림 손실을 방지하기 위해 재연결 시 테이블을 조회하는 전략도 설명합니다. 이 접근법은 분산 시스템에서 중복 메시지 처리와 장애 복구 문제를 효과적으로 해결합니다.

https://www.dbos.dev/blog/low-latency-reliable-messaging-with-postgres

#postgresql #distributedsystems #messaging #reliability #workflow

Christophe Pettus: All Your GUCs in a Row: autovacuum_vacuum_insert_scale_factor and autovacuum_vacuum_insert_threshold

https://postgr.es/p/9iI

#postgresql

🚀 Deploy #Odoo on Rocky Linux #VPS

This guide walks through the steps to deploy Odoo on Rocky Linux VPS using PostgreSQL, #Python virtual environment, #Nginx reverse proxy, and systemd. This setup is production-ready and appropriate for business deployments.
What Is Odoo?
Odoo is an open-source business management platform that integrates many core business functions into one ...
Continued 👉 https://blog.radwebhosting.com/deploy-odoo-on-rocky-linux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #letsencrypt #selfhosting #rockylinux #selfhosted #opensource #postgresql

I might have some #Django friends who have experience with this sort of thing.

I spent a good chunk of today doing #PostgreSQL query optimization: not indexes, but rather "if this query had a different but semantically-equivalent structure, the planner would understand how to make it an order of magnitude faster". I trimmed several seconds off the rendering time of some views. All very satisfying. (1/3)

Antony Pegg: pgEdge Control Plane Adds Supporting Services and a Preview of systemd Support

https://postgr.es/p/9iH

#postgresql

OH: dvd video streaming, but through the mail.

#PostgreSQL #Meetup #Berlin

Christophe Pettus: The Maintainer Is Not the Owner

https://postgr.es/p/9iG

#postgresql

Join us on Tuesday, May 12th at Noon PDT for "Postgres Defaults Worth Changing in Production" with Alex Yarotsky! That's just 5 days away! RSVP today!

https://www.meetup.com/postgresql-1/events/314529989/?isFirstPublish=true

@postgresql #PostgreSQL #postgres #meetup

Christophe Pettus: Eight Bytes Is the Easy Part

https://postgr.es/p/9iz

#postgresql

PGX is proud of our commitment to the PostgreSQL Community. That's why we encourage each of our employees to volunteer for PgUS and its affiliated conferences and User Groups.

https://pgexperts.com/corporate/community

#PostgreSQL #postgres