postgresql@xxxxxxxxx wrote: > Ah okay, thanks. I knew I could set various things but not > effective_work_mem (I tried reloading the edited config file but > it didn't seem to pick it up) Check the server log, maybe there was a typo or capitalization error. To test on a single connection you should be able to just run: SET effective_cache_size = '88GB'; By the way, one other setting that I have found a need to adjust to get good plans is cpu_tuple_cost. In my experience, better plans are chosen when this is in the 0.03 to 0.05 range than with the default of 0.01. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
