"Alvaro Herrera" <alvherre@xxxxxxxxxxxxxxxxx> writes: > Martin Langhoff escribió: > >> the whole thing of figuring out what the locale is and whether to add >> magical additional indexes just for Pg makes me look like a loony. > > You are right and Eloy is wrong on that discussion. There is not > anything the DB can do to use the regular index if the locale is not C > for LIKE queries. There are good reasons for this. There's not much > option beyond creating the pattern_ops index. Indeed *all* indexes are magical additional things added just for the one database. There's not any standard definition of what indexes you'll need for all databases out there. Indexes aren't even in the SQL standard because they're part of performance tuning for each individual database engine. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
