On Thu, Nov 17, 2011 at 2:10 PM, Jon Nelson <jnelson+pg...@jamponi.net> wrote: > What sorts of things should I be looking at to improve the performance > of this query? Is my interpretation of that log line totally off base?
You'll have to post some more details. Like a query and an explain/explain analyze. Memory consumption probably skyrockets since you'll need at least one sort per table, so if you have 100+, then that's (at least) 100+ sorts. Without the explain output it's impossible to be sure. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
