What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?
Date: 2013-01-22 17:57:46
Message-ID: BLU0-SMTP3088235BC9E3AA9F27181ADCF160@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm rephrasing the question I posted yesterday, because I have used the
wrong terminology and caused confusion (and for instance, got no
response to my question).

Almost all indexed columns of kind varchar in my database require
"varchar_pattern_ops" op class in order to make my LIKE queries more
optmized.

Is there any way to define that this operator class is the default for
my database for varchar columns?

What would be the impact in terms of performance and memory consumption?

Thanks,

Edson Richter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2013-01-22 18:07:44 Re: Restore 1 Table from pg_dumpall? [RESOLVED]
Previous Message Rich Shepard 2013-01-22 17:57:23 Restore 1 Table from pg_dumpall?