BUG #5530: Default cost of crypt causes poor decisions

Поиск
Список
Период
Сортировка
От Baegle
Тема BUG #5530: Default cost of crypt causes poor decisions
Дата
Msg-id 201006291948.o5TJm7VN031050@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5530: Default cost of crypt causes poor decisions
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged online:

Bug reference:      5530
Logged by:          Baegle
Email address:      al@wifiny.org
PostgreSQL version: 8.4.4
Operating system:   Linux - Ubuntu - Lucid Lynx - 2.6.31-19-generic
Description:        Default cost of crypt causes poor decisions
Details:

The default cost of crypt() is 1, but crypt is intentionally a high cost
function. This mis-match between assigned cost and actual cost causes the
query planner to use crypt too soon and slows down execution of queries
significantly. The cost of the function should be more congruent with it's
intended cost.

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

Предыдущее
От: dmp
Дата:
Сообщение: Re: [JDBC] JDBC: 2 bugs: Getting a smallint array actually gets an integer array and return type of a boolean array is bit.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"