Postgres Pro
Downloads
Home   >   mailing lists

Tell postgres which index to use? - Mailing list pgsql-performance

From Silke Trissl
Subject Tell postgres which index to use?
Date
Msg-id 420A3309.5040507@informatik.hu-berlin.de
Whole thread Raw
Responses Re: Tell postgres which index to use?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
Hi,

is there a way to tell Postgres which index to use when a query is
issued in 7.4.2?

I have a query for which costwise a Hash-Join and no Index-Usage is the
best, but timewise using the index and then do a NestedLoop join is much
better (3 - 4 times).

I have vacuumed before I started the comparison, so Postgres does its
best. And I don't constantly want to switch on and off the hashjoin and
mergejoin.

Regards,

Silke Trissl

pgsql-performance by date:

Previous
From: John A Meinel
Date:
Subject: Re: How can I make use of both CPUs in a dual processor
Next
From: Josh Berkus
Date:
Subject: Re: Tell postgres which index to use?