Re: 4s query want to run faster

["Adonias Malosso" <malosso@xxxxxxxxx>]

On Thu, Feb 21, 2008 at 6:10 PM, Claus Guttesen <kometen@xxxxxxxxx> wrote:

> The following query takes about 4s to run in a 16GB ram server. Any ideas
> why it doesn´t use index for the primary keys in the join conditions?

Maby random_page_cost is set too high? What version are you using?

Postgresql v. 8.2.1

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare