Debugging Postgres performance under Row-Level Security

engineering.myhoai.com English

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 register to comment.

PostgreSQL@programming.dev

postgresql@programming.dev

Create postModlog

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 is visible to everyone.

0 users / Day
5 users / Week
5 users / Month
6 users / 6 months
13 posts
0 comments
0 local subscribers
2.2K subscribers

Mods:
Ategon@programming.dev