On Thu, Aug 14, 2008 at 8:48 AM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > Try this... > > Set default_statistics_target to be 1000 in postgres.conf then reboot > your pg server. "Analyze" the table. Try the query again. A reload is enough. I think you might have to disconnect and reconnect your client, but I'm not sure.