On Thu, Nov 17, 2011 at 2:10 PM, Jon Nelson <jnelson+pgsql@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.