> 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? -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
