Functional index performance question
От
Mike Mascari
Тема
Functional index performance question
Дата
Msg-id
3F7963C9.6040605@mascari.com
Список
Дерево обсуждения
Functional index performance question Mike Mascari <mascarm@mascari.com>
Re: Functional index performance question Arguile <arguile@lucentstudios.com>
Re: Functional index performance question Tom Lane <tgl@sss.pgh.pa.us>
Re: Functional index performance question Mike Mascari <mascarm@mascari.com>
Re: Functional index performance question Arguile <arguile@lucentstudios.com>
Re: Functional index performance question Greg Stark <gsstark@mit.edu>
Let's assume I have a table like so: CREATE TABLE employees ( employeeid text not null, name text not null ); CREATE INDEX i_employees ON employees(lower(name)); Let's also assume that the lower() function is computationally expensive. Now if I have a query like: SELECT lower(name) FROM employees WHERE lower(name) = 'mike' will PostgreSQL re-evaluate lower(name)? Is it necessary? Mike Mascari mascarm@mascari.com
В списке pgsql-general по дате отправления