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