Postgres Pro
Downloads
Home   >   mailing lists

Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure. - Mailing list pgsql-performance

From Piotr Gasidło
Subject Re: Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.
Date
Msg-id a9eb4e580712130341y58f6c7c0j53166c0c788c32f4@mail.gmail.com
Whole thread Raw
In response to Index on VARCHAR with text_pattern_ops inside PL/PGSQL procedure.  (Piotr Gasidło <quaker@barbara.eu.org>)
List pgsql-performance
Tree view 
2007/12/10, Piotr Gasidło <quaker@barbara.eu.org>:
> Why PL/PGSQL is unable to proper utilize
> users_user_name_unique_text_pattern_ops?

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.

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Limited performance on multi core server
Next
From: "Kevin Grittner"
Date:
Subject: Heavy write activity on first vacuum of fresh TOAST data