2007/12/10, Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>:
> Why PL/PGSQL is unable to proper utilize
I found solution, that satisfies me (EXECUTE is a bit ugly for me).
I've replaced LIKE operator with ~=~ operator. Now PL/PGSQL function
properly uses index on SELECT.
In response to
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2007-12-13 15:46:17|
|Subject: Heavy write activity on first vacuum of fresh TOAST data|
|Previous:||From: Joshua D. Drake||Date: 2007-12-12 15:47:00|
|Subject: Re: Limited performance on multi core server|