The following bug has been logged online:
Bug reference: 5530
Logged by: Baegle
Email address: a...@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:
Baegle a...@wifiny.org writes:
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