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 по дате отправления
От: Bjørn T Johansen
Дата:
Сообщение: Re: Problem with lock?
От: Peter Eisentraut
Дата:
Сообщение: Re: Problem with lock?
FAQ