Home

repeated - Search results

List

Post date

Sort by

Mailing lists >> pgsql-performance >> Thread

2024-10-06 23:02:01 | Re: Performance degradation in Index searches with special characters (Shiv Iyer)

repeated queries involving long strings with special characters, try caching results or using

Mailing lists >> pgsql-performance >> Thread

2024-10-06 20:28:29 | Re: Performance degradation in Index searches with special characters (Andrey Stikheev)

repeated characters like <, it can severely degrade performance due to the extended processing

Mailing lists >> pgsql-performance >> Thread

2024-10-06 19:39:38 | Re: Performance degradation in Index searches with special characters (Tom Lane)

repeat('<', 65536); ?column? ---------- (0 rows) Time: 1383.033 ms (00:01.383) Poking into it with gdb says

Mailing lists >> pgsql-performance >> Thread

2024-10-05 12:23:56 | Performance degradation in Index searches with special characters (Andrey Stikheev)

repeat('<', 65536); ?column? ---------- (0 rows) Time: 4454.535 ms (00:04.455) testdb=# SELECT 1 FROM test