The following bug has been logged online:
Bug reference: 5530
Logged by: Baegle
Email address: al(at)wifiny(dot)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.