Worthwhile optimisation of position()?
От
Christopher Kings-Lynne
Тема
Worthwhile optimisation of position()?
Дата
Msg-id
44235FB9.5040202@calorieking.com
Список
Дерево обсуждения
Worthwhile optimisation of position()? Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Re: Worthwhile optimisation of position()? Thomas Hallgren <thomas@tada.se>
Re: Worthwhile optimisation of position()? Tim Allen <tim@proximity.com.au>
Re: Worthwhile optimisation of position()? Tom Lane <tgl@sss.pgh.pa.us>
Re: Worthwhile optimisation of position()? Thomas Hallgren <thomas@tada.se>
Re: Worthwhile optimisation of position()? Thomas Hallgren <thomas@tada.se>
Re: Worthwhile optimisation of position()? Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Re: Worthwhile optimisation of position()? Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
Re: Worthwhile optimisation of position()? "Jim C. Nasby" <jnasby@pervasive.com>
Is it worth allowing this:
select count(*) from users_users where position('ch' in username) = 0;
To be able to use an index, like:
select count(*) from users_users where username like 'ch%';
At the moment the position() syntax will do a seqscan, but the like
syntax will use an index.
Chris
В списке pgsql-hackers по дате отправления
