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: 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