Postgres Pro
Downloads
Home   >   mailing lists

What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")? - Mailing list pgsql-general

From Edson Richter
Subject What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?
Date
Msg-id BLU0-SMTP3088235BC9E3AA9F27181ADCF160@phx.gbl
Whole thread Raw
In response to What is impact of "varchar_opts"?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: What is the impact of "varchar_pattern_ops" on performance and/or memory  (Edson Richter <edsonrichter@hotmail.com>)
Re: What is the impact of "varchar_pattern_ops" on performance and/or memory (was: What is impact of "varchar_ops")?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Restore 1 Table from pg_dumpall?
Next
From: Rich Shepard
Date:
Subject: Re: Restore 1 Table from pg_dumpall? [RESOLVED]