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:
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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs