LeanpubLift the Elephant: Scaling PostgreSQL Beyond Query Optimization by Alex Yarotsky is the featured book on Leanpub!
Link: https://leanpub.com/lift-the-elephant
#Databases #Postgresql #DistributedSystems #SoftwareEngineering
The Daily PerspectiveAWS PostgreSQL Upgrade Trap: Why a Forced Security Move Created a Costly Production Catch-22
JohnnyD🚀 New blog post + django-rls-tenants 1.1.0 is out!
TL;DR: PostgreSQL RLS policies can't use your indexes because current_setting() isn't leakproof. The query planner falls back to sequential scans and applies tenant filtering row-by-row. On large tables, this hurts.
v1.1 fixes this by adding automatic ORM-level WHERE tenant_id = X alongside RLS - so Postgres uses your composite indexes for the fast path while RLS still enforces isolation as a safety net.
Also in this release:
→ select_related() now propagates tenant filters across joins
→ threading.local replaced with contextvars (ASGI-safe)
→ Superuser detection at startup (RLS is silently bypassed otherwise!)
→ Better exception handling in middleware
→ CASE WHEN policy rewrite for cleaner evaluation
Full write-up: https://dev.to/dvoraj75/postgresql-rls-is-fail-closed-but-is-it-fast-making-django-rls-tenants-index-friendly-2j18
GitHub: https://github.com/dvoraj75/django-rls-tenants
#Django #PostgreSQL #Python #MultiTenancy #RLS #OpenSource
PgUSThe next Postgres for All will be on March 18th! That’s tomorrow! Join us online for “Vibe Coding with Postgres” with Matt Cornillon:
https://www.meetup.com/postgres-meetup-for-all/events/313174491/?eventOrigin=network_page
Jimmy Angelakos 
New Blog Post: SCaLE 23x and CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes
https://vyruss.org/blog/scale-23x-cloudnativepg-robust-self-healing-postgresql-kubernetes.html
#SCaLE23x #PostgreSQL #Postgres #CloudNativePG #Kubernetes #K8s #CNCF #CloudNative #OpenSource #Database
Kovac IvanThe Oops Agent is done. Im finishing up final testing.
It provides true zero-knowledge end-to-end encryption.
Data is encrypted at the source before it ever touches the network.
Even if we were compromised, your data is secure.
#database #buildinpublic #mongodb #postgresql #mysql
It provides true zero-knowledge end-to-end encryption.
Data is encrypted at the source before it ever touches the network.
Even if we were compromised, your data is secure.
#database #buildinpublic #mongodb #postgresql #mysql
Douglas J Hunley#PostgreSQL 19: part 4 or CommitFest 2026-01 https://postgrespro.com/blog/pgsql/5972815
PostgreSQL 19: part 4 or CommitFest 2026-01
Continuing the series of CommitFest 19 reviews, today we’re covering the January 2026 CommitFest. The highlights from previous CommitFests are available here: 2025-07 , 2025-09 , 2025-11 . Partitioning: merging and splitting partitions pg_dump[all]/pg_restore: dumping and restoring extended statistics file_fdw: skipping initial rows Logical replication: enabling and disabling WAL logical decoding without server restart Monitoring logical replication slot synchronization delays pg_available_extensions shows extension installation directories New function pg_get_multixact_stats: multixact usage statistics Improvements to vacuum and analyze progress monitoring Vacuum: memory usage information vacuumdb --dry-run jsonb_agg optimization LISTEN/NOTIFY optimization ICU: character conversion function optimization The parameter standard_conforming_strings can no longer be disabled ...
mastodon.raddemo.host🚀 Install and Run Self-hosted #Mattermost Instance on Linux #VPS This article provides a comprehensive guide to install and run self-hosted Mattermost instance on Linux VPS (Ubuntu/Debian). This guide will set up Mattermost with #PostgreSQL and #NGINX as a reverse proxy with HTTPS.
What is Mattermost?
Mattermost is a self-hosted, open-source collaboration platform ...
Continued 👉 https://blog.radwebhosting.com/self-hosted-mattermost-instance/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #unifiedcommunications #selfhosting #opensource #letsencrypt #selfhosted #reverseproxy
What is Mattermost?
Mattermost is a self-hosted, open-source collaboration platform ...
Continued 👉 https://blog.radwebhosting.com/self-hosted-mattermost-instance/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #unifiedcommunications #selfhosting #opensource #letsencrypt #selfhosted #reverseproxy
PgDay BostonYour company can contribute to the PostgreSQL community by sponsoring events like PgDay Boston! We still have sponsorship opportunities available, so talk to us today!
EDBIntroducing EDB Postgres® AI - GPU Acceleration with NVIDIA RAPIDS Accelerator for Apache Spark, achieve predictable performance at scale for agentic analytics: https://www.enterprisedb.com/blog/achieving-predictable-performance-scale-agentic-analytics #PostgreSQL #NVIDIA #Spark
