On Sat, 06 Nov 2004 12:00:02 -0800, Mike Wertheim wrote:
> Does anyone have any suggestions on how to make this query run faster?
Does it help if you decrease the value of random_page_cost? - That value
can be changed run-time, from within psql. If you find that a certain,
lower value helps, you can make it permanent in postgresql.conf.
--
Greetings from Troels Arvin, Copenhagen, Denmark
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
