Debugging Postgres Performance Under Row-Level Security

Debugging Postgres Performance Under Row-Level Security engineering.myhoai.com

How an inefficient Row-Level Security policy drove Postgres CPU to 80%; and why EXPLAIN failed to reveal it.

2 points•bucket2015•2 days ago•1 comment•

#row #postgres #level #security #row level #level security #performance #debugging

1 comment

I feel that when we opt for row level security we are fundamentally moving away from CRUD principles and maybe not a good candidate in RDS. I have used this approach lock the rows from UI modifications, but felt like awkward way of restricting.

Read the full thread on Hacker News →

1 comment

Related stories