Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer differences between 7.2 and 7.3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Optimizer differences between 7.2 and 7.3
Date
Msg-id 4057.1058794682@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimizer differences between 7.2 and 7.3  (SZUCS Gábor <surrano@mailbox.hu>)
List pgsql-performance
Tree view 
=?ISO-8859-1?Q?SZUCS_G=E1bor?= <surrano@mailbox.hu> writes:
> do regex ops (~, ~*) use index scan in non-"C" locales? Is it worth to
> convert LIKE to regex?

The locale issues are the same either way.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Alexander Priem"
Date:
Subject: Re: Tuning PostgreSQL
Next
From: "Roman Fail"
Date:
Subject: Re: Tuning PostgreSQL