id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
24088	text/varchar_pattern_ops on PostgreSQL could be optional	djbug	nobody	"[https://code.djangoproject.com/ticket/12234 Bug report 12234] modified the index for char & text fields in PostgreSQL to use operator class `varchar_pattern_ops` & `text_pattern_ops` respectively. This makes the index usable for `LIKE` queries. 

However there isn't any discussion on the additional cost associated with making this as the default option. It would have been a good optional feature. Consider the `username` column in `user` table. How often do we need to do `LIKE` queries on this. 

But if this needs to be maintained for backwards compatibility, there should be an option to get a vanilla index (without `*_pattern_op` class) if the column will be used for simple lookups of the type`WHERE name = 'abc'`"	New feature	closed	Database layer (models, ORM)	dev	Normal	needsinfo			Unreviewed	0	0	0	0	0	0