Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??

Поиск
Список
Период
Сортировка
От David B
Тема Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??
Дата
Msg-id GOEGKICPFOPNLIEIHGFJGEJMCEAA.postgresql@thegatelys.com
обсуждение исходный текст
Ответы Re: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-sql
We have got used to the problem that queries of the format:

select *
from customer
where cust_id = '123' are much much faster than

select *
from customer
where cust_id = 123

(where cust_id is defined as bigint).

a. Why is this.

b. Will moving to v7.4 change this so we can avoid the whole '123' casting
thing.

Tx folks,
D



В списке pgsql-sql по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Fetch a single record
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Faster performance when using where cust_id = '123' vs cust_id = 123. Does 7.4 fix this??