Re: PgSQL 15.3: Execution plan not using index as expected

2023-08-12 Thread Dürr Software
Thanks Rob, no it's not a problem with the index. It's a problem with the use of CURRENT_USER in the WHERE I submitted a new post on this matter with a test case. Kind regards == Dürr Software Entw. Guggenberg 26, DE-82380 Peißenberg fon: +49-88

Re: PgSQL 15.3: Execution plan not using index as expected

2023-08-12 Thread Dürr Software
hope that this should clarify the problem. Thanks and kind regards == Dürr Software Entw. i...@fduerr.de Am 11.08.23 um 16:32 schrieb Adrian Klaver: On 8/11/23 03:11, Dürr Software wrote: Please reply to list also Ccing list Dear Adrian, thanks for the reply. Of course i ran A

PgSQL 15.3: Execution plan not using index as expected

2023-08-10 Thread Dürr Software
Inlining 120.073 ms, Optimization 70.361 ms, Emission 28.476 ms, Total 220.554 ms  Execution Time: 8438.307 ms (18 rows) Thanks a lot for your help -- == Dürr Software Entw. Guggenberg 26, DE-82380 Peißenberg fon: +49-8803-4899016 fax: +49-8803-4899017 i.