Josh Berkus wrote: > Folks, > > I turned on temp file logging for PostgreSQL to see if I needed to > adjust work_mem. Oddly, it's logging file usage up to 33 times per > executed query (and no, the query isn't large enough to need 33 separate > sorts).
Are you sure there's not a sort happening inside a loop? It might help if you posted the actual log messages along with the output of `EXPLAIN ANALYZE' on your query. -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
