Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: davidDate: 2009-01-27 07:51:33
Subject: Re: SSD performance
Previous:From: James MansionDate: 2009-01-27 06:37:39
Subject: Re: SSD performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group