vincent.moreau@xxxxxxxxxxxxxx wrote: > Here it is : > > CCM=# SHOW enable_mergejoin; > enable_mergejoin > ------------------ > on > (1 row) Sorry, my question was more general. Do you have _any_ of the planner types disabled? Try also enable_indexscan, etc; maybe select * from pg_settings where name like 'enable_%'; -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.