Odd behavior with temp usage logging

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Odd behavior with temp usage logging
Date: 2009-01-27 06:53:09
Message-ID: 497EAF55.6040605@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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).

Any idea what's going on here?

--Josh

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message david 2009-01-27 07:51:33 Re: SSD performance
Previous Message James Mansion 2009-01-27 06:37:39 Re: SSD performance