Postgres Pro
Downloads
Home   >   mailing lists

BUG #5530: Default cost of crypt causes poor decisions - Mailing list pgsql-bugs

From Baegle
Subject BUG #5530: Default cost of crypt causes poor decisions
Date
Msg-id 201006291948.o5TJm7VN031050@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5530: Default cost of crypt causes poor decisions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: dmp
Date:
Subject: Re: [JDBC] JDBC: 2 bugs: Getting a smallint array actually gets an integer array and return type of a boolean array is bit.
Next
From: Tom Lane
Date:
Subject: Re: Function works in 8.4 but not in 9.0 beta2 "ERROR: structure of query does not match function result type"