Loading feed…
Planet PostgreSQL0 Hot0 comments10 min read
PgBouncer and RLS: tenant context, SET LOCAL, shared plans
AI summary
PgBouncer chạy ở chế độ transaction có thể gây rò rỉ tenant context trong RLS do cách xử lý SET LOCAL. Kết đoán cho thấy khi dùng SET LOCAL ngoài transaction, giá trị vẫn tồn tại đến khi kết thúc session, không chỉ transaction. Điều này gây ra kế hoạch query bị share giữa các tenant, dẫn đến performance issue vì filter condition không được áp dụng đúng. Bài viết đưa ra số liệu cụ thể về impact và giải pháp sử dụng pgbouncerpool thay vì connection pool thông thường để tránh vấn đề này.
AI summaries can be wrong. Read the original before relying on anything important.
Why read it: Bài này giúp hiểu các vấn đề bảo mật và hiệu năng khi RLS hoạt động cùng PgBouncer trong chế độ transaction.
What do you remember?
Answer 3 short questions to earn reward points for this article. Only do it if you want the points.
up to +17 points
3 questions · under a minute · optional
Source: https://postgr.es/p/9wD. 8 Sync News only summarizes and links out; content copyright belongs to the authors and original sources.
8 Sync ecosystem
One account, the whole ecosystem
Read the news here, practice coding, follow structured courses and train for IELTS on our sibling products — all connected through one 8 Sync account.
8syncdev.com
8syncdev.comThe ecosystem home: product overviews, blog and full pricing.
ExploreCourses
course.8syncdev.comLearn along a clear roadmap: videos, auto-graded quizzes, certificates and mentors who ship for a living.
View the roadmapCoding practice
coding.8syncdev.com1,000 DSA problems in Vietnamese, auto-graded across 7 languages — many FREE, right in your browser.
Practice for freeIELTS
ielts.8syncdev.comAI grading for all four IELTS skills with detailed rubric feedback.
Try it freeZUS — AI IDE
zus.8syncdev.comA 22 MB AI IDE for Vietnamese devs.
Download freemind0
mind0.8syncdev.comOrganizational memory for AI agents.
ExploreAcoLeads
home-acoleads.8syncdev.comAI that staffs your Fanpage and qualifies leads for you.
Try itRecommended for you
RUBYLAND0 Hot3 min
A database per git worktree that barely uses any disk space
Postgres 18’s new file_copy_method = clone setting lets you give every git worktree its own copy of your database in seconds, without eating up your disk.
Planet MySQL1 Hot6 min
Vector search in MySQL: from a plugin to the top of the Contributor Summit agenda
This week vector search opened the MySQL Contributor Summit. A plugin started the fire, the M-ecosystem picked it up, the hyperscalers went native, and now the benchmark wars have begun.
Planet PostgreSQL1 Hot15 min
json vs jsonb in PostgreSQL: size and speed, measured
json vs jsonb in PostgreSQL 17 and 18, measured on six document shapes: when jsonb is 23% smaller or 41% larger, read speed, GIN, and what it changes.
Planet PostgreSQL0 Hot8 min
Two migrations collide: one loud failure, one silent one
Two incompatible migrations merge clean, then resolve in the database — as a failed deploy in one environment and a healthy one in another, decided by apply order. The idempotent version is worse: every statement succeeds and the schemas silently diverge.
Hacker News69 Hot1 min
OccupySaaS
OccupySaaS is a protest movement in code: laid-off developers building clean-room, open-source, drop-in replacements for the SaaS giants. First up: ZeroAuthy (Auth0) and SalesCompel (Salesforce).
Milan Jovanović10 Hot10 min
Outbox Pattern in .NET With Postgres: Concurrent Workers vs the WAL
An API can save an order and crash before publishing the message that tells other services about it.
freeCodeCamp29 Hot16 min
How to Automate Docker Image Creation for Postgres Using Shell Commands
If you have certain lines of code that repeat over and over again in a project, there's a pretty standard solution for it: using a function. But what about when you have the same project file setup th
ITNEXT26 Hot56 min
Kubernetes Multi-Tenancy, Layer by Layer: Isolation Proved by Being Refused
“” is published by Filipe Motta in ITNEXT.
Comments
Loading comments…