Debugging Postgres performance under Row-Level Security

engineering.myhoai.com

Debugging Postgres performance under Row-Level Security

engineering.myhoai.com

codeinabox@programming.dev to

PostgreSQL@programming.devEnglish · 3 months ago

Debugging Postgres performance under Row-Level Security | HOAi

engineering.myhoai.com

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

You must log in or # to comment.

Chat

PostgreSQL@programming.dev

postgresql@programming.dev

Create a post

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !postgresql@programming.dev

The world’s most advanced open source relational database

Project

About (history)
Docs
Donate to PostgreSQL
Wiki
Planet PostgreSQL
IRC
Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
User Groups

Events

SEAPUG Summer BBQ, 6 July in Seattle
SFBA PostgreSQL Meetup, 12 July
Chicago PostgreSQL Meetup, 19 July
PGDay UK 2023, 12 September in London
PGConf 2023, 3-5 October in New York City
PGDay Israel 2023, 19 October
PGConf.EU 2023, 12-15 December in Prague

Podcasts

postgres.fm (feed)

Related Fediverse communities

c/SQL on programming.dev
#sql on Mastodon
#postgresql on Mastodon

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

19 users / day
19 users / week
19 users / month
19 users / 6 months
1 local subscriber
2.28K subscribers
42 Posts
0 Comments
Modlog