Re: Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Achilleas Mantzios
Στις 27/6/24 17:58, ο/η Laura Hausmann έγραψε: Heya & thank you for the response! That makes a lot of sense. I'm glad to hear it's on the radar of the team, but I understand that this is a complex task and won't happen anytime soon. For the meantime, I've tried a couple ways of rewriting the

Re: Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Laura Hausmann
Heya & thank you for the response! That makes a lot of sense. I'm glad to hear it's on the radar of the team, but I understand that this is a complex task and won't happen anytime soon. For the meantime, I've tried a couple ways of rewriting the query, sadly none of which seem to translate to the

Re: Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Achilleas Mantzios - cloud
On 6/27/24 03:50, Laura Hausmann wrote: Heya, I hope the title is somewhat descriptive. I'm working on a decentralized social media platform and have encountered the following performance issue/quirk, and would like to ask for input, since I'm not sure I missed anything. I'm running PostgreS

Re: Row level security

2024-06-27 Thread Andrew Okhmat
Hello Jim, Your approach of using table inheritance in PostgreSQL for implementing row-level security (RLS) has some interesting aspects, but there are potential pitfalls and alternatives that you should consider. Below, I'll outline some key points to Table Inheritance and Performance Conce

Re: Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Andrei Lepikhov
On 6/27/24 07:50, Laura Hausmann wrote: I'd appreciate any and all input on the situation. If I've left out any information that would be useful in figuring this out, please tell me. Thanks for this curious case, I like it! At first, you can try to avoid "OR" expressions - PostgreSQL has quite

Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Laura Hausmann
Heya, I hope the title is somewhat descriptive. I'm working on a decentralized social media platform and have encountered the following performance issue/quirk, and would like to ask for input, since I'm not sure I missed anything. I'm running PostgreSQL 16.2 on x86_64-pc-linux-gnu, compiled by gc